Sumifs

0

Hi, I am doing a practice exercise on Sumifs function on the attached excel. For Table A i need to calculate the COGS value with Region & Product A as Criteria. But the Sumrange colums contains #NA & Ref errors which does not allow formula to work.

Can you please help me out on this? I am using the following Syntax

=SUMIFS(F5:F2003,E5:E2003,I18,B5:B2003,J17)

it gives #N/A error instead of result.

Answer
Discuss

Discussion

If the answer worked, you must click the "Select Answer" button. Also, you need to delete the "answer" you made saying it worked. Please read the instructions!
don (rep: 1317) Sep 5, '16 at 8:46 pm
Add to Discussion

Answers

0
Selected Answer

For one of your criterias you can put this:

"<>#N/A"

Often just make one of the criterias >0

Here is a formula I tried that worked in the spreadsheet you attached:

=SUMIFS(F5:F2003,E5:E2003,I18,B5:B2003,J17,F5:F2003,">0")
Discuss
0

Thanks. it worked.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login