software

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 gt;1),--(e5:e124=0),e5:e124)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;heaterquot; gt; wrote in message
...
gt; I need a formula that will look at e5:e124 first, then at g5:g124. If
gt; e5:e124 is greater than 1 and g5:g124 is blank or zero then it will sum
the
gt; number in e5:e124.
This formula works like this - =IF((AND(SUM(E14)gt;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.

quot;Nikkiquot; wrote:

gt;
gt; =IF((AND(SUM(E5:E124)gt;1,SUM(G5:G124)=0)),SUM(E5:E1 24),0)
gt;
gt; quot;heaterquot; wrote:
gt;
gt; gt; I need a formula that will look at e5:e124 first, then at g5:g124. If
gt; gt; e5:e124 is greater than 1 and g5:g124 is blank or zero then it will sum the
gt; gt; number in e5:e124.


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

quot;heaterquot; wrote:

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