Running Total, If formula?

[natei6]

=IF($D20=TODAY(),SUM($E$3:E20),"")

Greetings,

I am using the formula above for a Running total. I am wanting to modify it so that my running total of column E starts from zero every time the date in Column D changes. I thought the "=Today()" would work but obviously it totals the whole column.

Thanks in Advance

Nathan Sargeant

[natei6]

=IF($D20=TODAY(),SUM($E$3:E20),"")

Greetings,

I am using the formula above for a Running total. I am wanting to modify it so that my running total of column E starts from zero every time the date in Column D changes. I thought the "=Today()" would work but obviously it totals the whole column.

Thanks in Advance

Nathan Sargeant

P.S. Is this possible?

[RES]

If I understand correctly
you have dates in Column D
Numbers to be totaled in Column E
Running Total in Column F

=IF(D20=D19,F19+E20,E20)

in words if the date is the same on this line as the one before
then add the number on this lne to the running total
otherwise just put the number on this line into the running total

Hope this helps

RES

[natei6]

If I understand correctly
you have dates in Column D
Numbers to be totaled in Column E
Running Total in Column F

=IF(D20=D19,F19+E20,E20)

in words if the date is the same on this line as the one before
then add the number on this lne to the running total
otherwise just put the number on this line into the running total

Hope this helps

RES

Thankyou!

So simple and yet soooo wonderful

Nathan Sargeant