If formula...

[heater]

I need a formula that looks at a column and if that column has a "0" input in
it, then add the number in the cell next to it. I have tried -
IF(H5:H70=0,sum(G5:g70,"")).

 

[David Biddulph]

=SUMPRODUCT((H5:H70=0)*(H5:H70<>"")*G5:G70), assuming that you don't want to
include those rows where column H is empty.

 

[FSt1]

hi.
Try this....
=IF(SUM(H5:H70)=0,SUM(G5:G70),"")

Regards
FSt1

 

[T. Valko]

Try this:

=SUMIF(H5:H70,0,G5:G70)

 

[JE McGimpsey]

One way:

=SUMIF(H5:H70,0,G5:G70)