software

My problem is some of the values in the sum_range are quot;#valuequot;. This will
not remain true all the time in this range, so, I need a formula that will
exlcude thequot;#valuequot; cells. Of course, the result I obtain from the formula
below is #value.

=SUMIF(G21:G30,quot;testquot;,S21:S30)

Thanks...

Hi

=IF(ISERROR(SUMIF(G21:G30,quot;testquot;,S21:S30)),quot;quot;,SUMI F(G21:G30,quot;testquot;,S21:S30))--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;Vegsquot; gt; wrote in message
news
gt; My problem is some of the values in the sum_range are quot;#valuequot;. This will
gt; not remain true all the time in this range, so, I need a formula that will
gt; exlcude thequot;#valuequot; cells. Of course, the result I obtain from the
gt; formula
gt; below is #value.
gt;
gt; =SUMIF(G21:G30,quot;testquot;,S21:S30)
gt;
gt; Thanks...
Hello Arvi,
I should have mentioned that some cells in the sum_range do contain
numerical values while some are errors. When I apply this formula the result
is quot;nothingquot;. I still need the sum of the cells containing numerical values.
Thank you...

quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; =IF(ISERROR(SUMIF(G21:G30,quot;testquot;,S21:S30)),quot;quot;,SUMI F(G21:G30,quot;testquot;,S21:S30))
gt;
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
gt;
gt;
gt;
gt; quot;Vegsquot; gt; wrote in message
gt; news
gt; gt; My problem is some of the values in the sum_range are quot;#valuequot;. This will
gt; gt; not remain true all the time in this range, so, I need a formula that will
gt; gt; exlcude thequot;#valuequot; cells. Of course, the result I obtain from the
gt; gt; formula
gt; gt; below is #value.
gt; gt;
gt; gt; =SUMIF(G21:G30,quot;testquot;,S21:S30)
gt; gt;
gt; gt; Thanks...
gt;
gt;
gt;