View Full Version : Blank Cell When Running Totaling


skilche1
10-11-2007, 08:42 AM
I am doing a running total to keep track of expenditures. How can I have a blank cell when the running totaling formulas has been copied cells under the last calculation? Please view the attached pic to view how it looks today.

Thanks in advance,

~Kilch :D

shades
10-11-2007, 02:39 PM
Howdy. If you put this formula in E5

=IF(B5="","",SUM(E4,B5))

And copy down.

Will this work?

skilche1
10-12-2007, 04:51 AM
Dude,

This worked beautifully. Much appreciated :D,

Have a great weekend and thanks again,

~Kilch

Howdy. If you put this formula in E5

=IF(B5="","",SUM(E4,B5))

And copy down.

Will this work?