What if the range is as follows: B3, B5, C8, D12, E32

How do you enter that into the "Range" part of the SumIf?

Thanks,

Jim

"Aladin Akyurek" wrote:

To sum a range housing #N/A's and numbers, try:

=SUMIF(Range,"<#N/A")

claytorm wrote:
Hi,

I have a string of IF conditions, which I am combining with SUM. I want
to get the IF conditions to ignore any cells containg the error message
#N/A. How can I do this?

Thanks,
Bertie.