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?