Sum of cells

[bbc1]

I have a worksheet with a group of cells Say A1:A12 which
I need to total A13, I also have a another row of cells
B1:B12 which I need to total B13 as well, and added to
the first total so that it gives me a running total. My
problem is how do I stop the second total from showing
the first total before a figure is added to the second
group of cells. In other words I want B13 to show 0 until
a value is placed in B1:B12

 

[Frank Kabel]

Hi
try the following formula in B13:
=IF(COUNTA(B1:B12),SUM(B1:B12)+A13,0)

 

[Guest]

Thankyou I modified the formula to suit and it works fine

 

[bbc1]

Thankyou modified formula to suit my needs and works fine.

 

[icestationzbra]

if i understand your question correctly:

if A1, A2, B1, B2 have values in them, A3 and B3 are to hold th
totals, place this formula in B3:

=IF(COUNT(B1:B2)<2, 0, SUM(B1:B2,A3)