I know there's an easy way to do this, but I've had a brain freeze for too
long. I have several worksheets that keep a running balance of various
accounts. I want to take the outstanding balance on each worksheet to get a
total of all sheets. I've found a method that works, but it's convoluted and
looking to stop these headaches!
Col F
-----
Running balance that is empty unless there's an entry in Cols D or E

Col G
-----
Simple "=F" but gives text "blank" if no entries.

Col H
-----
=IF(AND(G9="blank"),IF(G8<$G$1,G8,0)) with this formula at H9, where G1=0,
I get an "ERROR" in rows that have data, the text "blank" in unused rows and
a figure in the last used row.

I then sum Col H to the same cell in all worksheets and get my grand total
from these. PHEW.....OK, so what's the ez solution?? This works, but I HATE
not seeing the obvious ez solution. Thanks for your thoughts!

--
Virg