IFERROR for a multiple selection range

[Jrlcb]

I’m trying to find the sum of a given range ignoring errors.

The formula I’m using goes like this:
=SUM( IFERROR( (A1,A10,A15,…) ,0) )

Which works with horizontal(A1:B1),vertical (A1:A2) and mixed(A1:B2) ranges. But not with multiple selection ranges.

Is there a way to make this work with a range of non-adjacent cells?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=AGGREGATE(9,6,(A1:A2,A10,B3:C5))

 

[Jrlcb]

Hi & welcome to MrExcel.
How about

=AGGREGATE(9,6,(A1:A2,A10,B3:C5))

Worked perfectly, Thanks You

 

[Fluff]

You're welcome & thanks for the feedback.

 

[mrgie]

Hi & welcome to MrExcel.
How about

=AGGREGATE(9,6,(A1:A2,A10,B3:C5))

Hi, not sure if I should make a separate post.
I have a similar problem. Is there a way to do this if the reference itself was the error?
ie:

=AGGREGATE(9,6,(A1,A10,B3,#REF!))

 

[Fluff]

Hi & welcome to MrExcel.
I'm not sure what you mean, but it's best to start a new thread & post some sample data using the XL2BB add-in.