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