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.

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"heater" wrote in message
...
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.

=IF((AND(SUM(E5:E124)1,SUM(G5:G124)=0)),SUM(E5:E1 24),0)

"heater" wrote:

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.