SUM 2 COUNTIFS functions #INCORRECT ARGUMENT error
I am trying to sum 2 countifs functions and I am unsure why I am getting an error. I was hoping someone could help me fix this error.
=SUM((COUNTIFS({Jade3_BCM Dashboard 2019 Range 1}, "Examine & Validate", {Jade3_BCM Dashboard 2019 Range 4}, "Execute on Timelines", {Jade3_BCM Dashboard 2019 Range 3}, "1st Quarter")), (COUNTIFS({Jade3_BCM Dashboard 2019 Range 1}, "Execute on Timelines", {Jade3_BCM Dashboard 2019 Range 5}, "Examine & Validate",{Jade3_BCM Dashboard 2019 Range 3}, "1st Quarter")))
They work separately, but will not sum together in the same cell for some reason. I am referencing two columns with the primary and secondary objectives for the task. Sometimes a person will put Examine & Validate in the primary and Execute on Timelines in the secondary. Other times they will do the opposite, so I want to add both of these potential results together for the 1st Quarter.
Comments
-
There are a couple of ways to fix this. To continue using the SUM function posted above, you would need to remove some parenthesis. The easiest way to explain which ones would be that you do not need to wrap your COUNTIFS formulas in an extra set. It should just look like this:
=SUM(COUNTIFS(.....................), COUNTIFS(..................))
You could also remove the SUM function and just add the two working COUNTIFS together.
=COUNTIFS(.................) + COUNTIFS(...................)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!