Skip to main content
1 of 4
user avatar
user avatar

Google Sheets COUNTIFS Range of cells as criteria possible?

In the google sheets Formula =Countifs, is it possible to have a range as a criteria, for example:

=COUNTIFS(ExampleSheet!A1:A10, "Some criteria", ExampleSheet!B1:B10, List_of_Names!C1:C)

I coudnt find a solution to this, is there any way of doing this. Basically I need to compare a filter against a list ofnames in a column in the second criteria.

Thanks!

SJS