Sum of cells

  • Thread starter Thread starter bbc1
  • Start date Start date
B

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
 
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)
 
Back
Top