I've been spinning my wheels on this one for a while now and I am ready to tag in a friend... Referencing the attached image, I am trying to: Count the number of occupied cells in D2:H Based on the strings present in columns A-C Using criteria from another sheet (represented here in J4:K8) So in the example shown, I'm trying to count the number of used slots in July, in Asia, on Platform A (answer would be 3). If I changed the criteria to August, Asia, A, then the answer would be 2 If I changed to October, Europe, C, then the answer would be 0 I am very stuck -- anyone have a solution for this one? Thanks! -Chris

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

GSheets - Count Cells in an Array based on criteria in Columns

Thread starter ChrisLaR
Start date Aug 2, 2022
Tags

googlesheets

ChrisLaR

New Member

Aug 2, 2022

I've been spinning my wheels on this one for a while now and I am ready to tag in a friend...

Referencing the attached image, I am trying to:

Count the number of occupied cells in D2:H
Based on the strings present in columns A-C
Using criteria from another sheet (represented here in J4:K8)

So in the example shown, I'm trying to count the number of used slots in July, in Asia, on Platform A (answer would be 3).
If I changed the criteria to August, Asia, A, then the answer would be 2
If I changed to October, Europe, C, then the answer would be 0

I am very stuck -- anyone have a solution for this one?

Thanks!
-Chris