Running Total, If formula?

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

Originally Posted by 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

Thankyou!

So simple and yet soooo wonderful

Nathan Sargeant