Count Index Match Formula

Rosetta Gordon

I want a formula to retrieve a count of how many nurses have a BSN degree by unit from a spreadsheet. I have a sheet with the list of units as the primary column and degrees listed for the other columns. The formula needs to look at the main data sheet for this number. Is this possible?

Paul Newcome

You would need a COUNTIFS function.

=COUNTIFS({Source Sheet Unit Column}, @cell = "Unit A", {Source Sheet Degree Column}, @cell = "BSN")