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