software

Hi,

What do I need to add to the below formula, to get the return result as
quot;zeroquot;, when one of the cell in column AO is not quot;Yquot;. Prensently, the return
result is #DIV/0!.

=SUMPRODUCT(--('ES 0421'!$AC$2:$AC$1903=$B13),--('ES
0421'!$AO$2:$AO$1903=quot;Yquot;),('ES 0421'!$AI$2:$AI$1903)/A2)

Thanks,
Priscilla

You will only get #div/0! if A2 is 0.

quot;Priscillaquot; wrote:

gt; Hi,
gt;
gt; What do I need to add to the below formula, to get the return result as
gt; quot;zeroquot;, when one of the cell in column AO is not quot;Yquot;. Prensently, the return
gt; result is #DIV/0!.
gt;
gt; =SUMPRODUCT(--('ES 0421'!$AC$2:$AC$1903=$B13),--('ES
gt; 0421'!$AO$2:$AO$1903=quot;Yquot;),('ES 0421'!$AI$2:$AI$1903)/A2)
gt;
gt; Thanks,
gt; Priscilla

Yes cell A2 is quot;zeroquot;, is there anyway I can get around that.

quot;Toppersquot; wrote:

gt; You will only get #div/0! if A2 is 0.
gt;
gt; quot;Priscillaquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; What do I need to add to the below formula, to get the return result as
gt; gt; quot;zeroquot;, when one of the cell in column AO is not quot;Yquot;. Prensently, the return
gt; gt; result is #DIV/0!.
gt; gt;
gt; gt; =SUMPRODUCT(--('ES 0421'!$AC$2:$AC$1903=$B13),--('ES
gt; gt; 0421'!$AO$2:$AO$1903=quot;Yquot;),('ES 0421'!$AI$2:$AI$1903)/A2)
gt; gt;
gt; gt; Thanks,
gt; gt; Priscilla



=IF (A2lt;gt;0,SUMPRODUCT(--('ES 0421'!$AC$2:$AC$1903=$B13),--('ES
0421'!$AO$2:$AO$1903=quot;Yquot;),('ES 0421'!$AI$2:$AI$1903)/A2),0)

this will set cell to 0 if A2 is 0HTHquot;Priscillaquot; wrote:

gt; Yes cell A2 is quot;zeroquot;, is there anyway I can get around that.
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; You will only get #div/0! if A2 is 0.
gt; gt;
gt; gt; quot;Priscillaquot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; What do I need to add to the below formula, to get the return result as
gt; gt; gt; quot;zeroquot;, when one of the cell in column AO is not quot;Yquot;. Prensently, the return
gt; gt; gt; result is #DIV/0!.
gt; gt; gt;
gt; gt; gt; =SUMPRODUCT(--('ES 0421'!$AC$2:$AC$1903=$B13),--('ES
gt; gt; gt; 0421'!$AO$2:$AO$1903=quot;Yquot;),('ES 0421'!$AI$2:$AI$1903)/A2)
gt; gt; gt;
gt; gt; gt; Thanks,
gt; gt; gt; Priscilla