Formula Question - Pulling in Multiple Criteria
I currently have a couple COUNTIFS formulas where I'm capturing the type by person by month as my criteria. I need to keep this criteria but add the condition that if multiple workers is selected in the source sheet (in a drop down with 3 options), to count the number in the correlating # of multiples column. The problem I've run into is I don't need it to just count that number, but take that number and + it with the other criteria to count.
In summary, I am trying to count the number of columns a person appears within my criteria + pull in the multiples column to add in that specific number (and not just count as 1).
Hopefully this makes sense. Any insight is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!