COUNTIFS Range with multiple columns?
Can I use a range with multiple columns in a COUNTIFS statement? I'm trying to setup a Summary Metrics sheet that can use one formula to summarize data from a skills registry table. The source table looks like this:
And our current summary table is set up like this:
Right now, we created a referenced range for each individual column in the roster. But now that we want to create different summaries for "Silo" rows that contain "Architect" and other terms, that's a lot of cells to edit. So, I'm wondering if COUNTIFS can accept a single reference range of ALL the columns and then use the @row value (such as Revit, Dynamo, etc.) to inform the COUNTIFS statement.
Help Article Resources
Check out the Formula Handbook template!