Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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.

excel
MS Office Version: aNKIT
posted by: aNKIT (rep: 4) on Sun Sep 4, 2016 at 11:09 am
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: 1989) 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")
posted by: don (rep: 1989) on Mon Sep 5, 2016 at 11:33 am
Discuss
0

Thanks. it worked.

posted by: aNKIT (rep: 4) on Mon Sep 5, 2016 at 12:35 pm
Discuss


Answer the Question

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