Sum Formula

[James Carlo Cruz]

Hi,

Is there a formula for sum in excel that would change depending on the date:
i.e.

Day 1 = 1 outcome Day 1 = 1
Day 2 = 2 outcome Day 2 = 3
Day 3 = 3 outcome Day 3 = 5

 

[S. Das]

Would you please clarify your need??

 

[James Carlo Cruz]

in the attached file, if you look at the sum column, that's how I want the formula to execute when I drag it down. hope that helps?

 

[S. Das]

I think you want something like this

 

[S. Das]

I think you want something like this

Tell me if this is helpful

 

[GraH - Guido]

alternatively refer in C2 to the cell B2 =B2. And in cell C3 =C2+B3 and this you can drag down.
This might be better in case you are dealing with large columns in large files with lots of formulas. The formula presented by S.Das references more and more cell addresses each time it continues down. This could become a problem in large files, since it consumes more memory.

 

[chirayu]

In cell C2. Type this formula & drag down =SUM($B$2:B2)