COUNITFS w/Ranges from Multiple Sheets?
I'm trying to create a COUNTIFS formula that will look for the same criteria within multiple sheets (5+ sheets at a time). I have my criteria in one sheet, and want to look across other sheets for instances of that specific criteria, then tally up the instances in the original sheet w/the criteria. I'm setting a range per sheet that's limited to the column in which the specific criteria may appear.
Help Article Resources
Check out the Formula Handbook template!