If formula...

H

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,"")).
 
D

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.
 
Top