How to add an additional complex countif to an established sumproduct/countif?

I have a file attached that is currently counting the various codes in column D of the Summaries tab based on the descriptions in column B of the Schedule Codes tab.

I would like to have an initial screening based on the managment areas in column C of the Summaries tab. I copied all of the info I had for area 1A two times. That is why the current formulas show 3 times what the answer should be. I would like each Summary box on the Summaries tab to only show the information if the area in column C matches what is in row 2 of the summary boxes.

What should I add to my current formulas to do this?

Who is Participating?

Improve company productivity with a Business Account.Sign Up

barry houdiniConnect With a Mentor Commented:
You can change the COUNTIF part of the formula to a COUNTIFS to check the extra criterion, e.g. with this formula in I3

=SUMPRODUCT(--ISNUMBER(SEARCH("residential",'Schedule Codes'!$B$1:$B$1000))*COUNTIFS($C$1:$C$973,I2,$D$1:$D$973,'Schedule Codes'!$A$1:$A$1000))

....and similar for your other calculations

regards, barry
Dominator1025Author Commented:

Awesome as always, thanks!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.