=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