Excel / Google Sheets 'SUM' repeating help please :)

Associate
Joined
5 Mar 2003
Posts
1,580
Location
Swadlincote
I've got a google sheets spreadsheet which i have multiple 'sums' on it. How can i repeat those sums down the columns without it filing in Zero's all the way down? If i don't 'drag' the formula down (and get all the zeros!) it means having to individually drag down the 'sum' on every cell i populate and there are about 12 columns worth of numbers.

Basically, i only want the sum to appear when i have filled that particular cell and not show gobbledygook or a zero beforehand.

I'm sure there must be an easy answer to this and i hope my question makes sense.

Any help appreciated. Thank you.
 
Associate
OP
Joined
5 Mar 2003
Posts
1,580
Location
Swadlincote
No, i've got in a pickle with that. So here is the first sum and i want to bring that down to Row 9,10, 11 etc etc and not show anything if the value is zero . =SUM(D8-B8)
 
Soldato
Joined
18 Oct 2002
Posts
3,515
Location
UK
=IF(SUM(D8-B8)=0,"",SUM(D8-B8))

although if you really are doing SUM(D8-B8) then you don't actually need the SUM function

=D8-B8 gives the same result as =SUM(D8-B8)
 
Back
Top Bottom