Sumif...SumProduct...Sum Something

H

heater

I need a formula that will look at e5:e124 first, then at g5:g124. If
e5:e124 is greater than 1 and g5:g124 is blank or zero then it will sum the
number in e5:e124.
 
B

Bob Phillips

=SUMPRODUCT(--(e5:e124 >1),--(e5:e124=0),e5:e124)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
H

heater

This formula works like this - =IF((AND(SUM(E14)>1,SUM(G14)=0)),SUM(E14),0),
but when the formula Nikki wrote below, it returns a zero answer. I guess
the problem is looking at more than one cell (e5:e124). Any more suggestions.
 
Top