SUMIF

V

Vegs

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

=SUMIF(G21:G30,"test",S21:S30)

Thanks...
 
A

Arvi Laanemets

Hi

=IF(ISERROR(SUMIF(G21:G30,"test",S21:S30)),"",SUMIF(G21:G30,"test",S21:S30))
 
V

Vegs

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 "nothing". I still need the sum of the cells containing numerical values.
Thank you...
 
Top