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

Doosht · 13 Jun 2019 at 13:59

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.

james.miller · 13 Jun 2019 at 14:45

Change the cell format to hide zeros or change the formula to check the contents of the cells you are summing first ie =if(a1="","",sum(a1:d1))

Doosht · 13 Jun 2019 at 17:02

Hi, thank you very much - i will try that.

Doosht · 13 Jun 2019 at 17:22

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)

BigT · 13 Jun 2019 at 17:38

=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)

Doosht · 13 Jun 2019 at 17:59

BigT said:
=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)

Perfect, thank you!

james.miller · 13 Jun 2019 at 18:20

BigT said:
=IF(SUM(D8-B8)=0,"",SUM(D8-B8))

This ignores zeros, better to use =if(d8="","",d8-b8)