SUMIFS with a formula

[Subtle]

Hello

I am trying to sum the values of a formula with two conditions. I am using "SUMIFS" function but its giving me an error.

Could anyone help please?

Edit: Here is the explaination of what I am trying to achieve.

I have this formula:
(A1:A9+B1:B9)/(C1:C9-D1:D9)

Simply, addition of values in column A and B then divided by (column C - column D). Then total sum of all results. I am trying to write this formula in A12 (attached spreadsheet).

However, if the Column C - Column D result is zero, the formula will generate an error.

So if I just simply write Sum((A1:A9+B1:B9)/(C1:C9-D1:D9)), it would generate error because some of the values will be dividing by zero.

To solve this, I am trying to give it a condition where it only sums the values based on "non zero" column C and D.

Thanks

[janmorris]

where are the expected results (and/or explanation, preferably both) so that we can understand what you are trying to achieve?

[Subtle]

Sorry. I have updated the original post. Thanks.

[Fluff13]

How about

Please Login or Register  to view this content.

[janmorris]

try this:

Please Login or Register  to view this content.

[Subtle]

Thank you both. Although it works, I am not a big fan of IFERROR() as it has a potential to mask any other errors that may be important to know. I take it as there is no other way but to use IFERROR()?

[Fluff13]

You could try

Please Login or Register  to view this content.

which will need array entry for xl2010

[Subtle]

Awesome. Thank you.

[Fluff13]

Glad to help & thanks for the feedback.