Try the following...

=SUM(IF(ISNUMBER(CHOOSE({1,2,3,4,5},B3,B5,C8,D12,E 32)),CHOOSE({1,2,3,4,5}
,B3,B5,C8,D12,E32)))

....confirmed with CONTROL+SHIFT+ENTER, or...

=SUM(IF(ISNUMBER(N(INDIRECT({"B3","B5","C8","D12", "E32"}))),N(INDIRECT({"
B3","B5","C8","D12","E32"}))))

....or, let A1:A5 contain B3, B5, C8, D12, and E32, and try...

=SUM(IF(ISNUMBER(N(INDIRECT(A1:A5))),N(INDIRECT(A1 :A5))))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
jim314 wrote:

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.