mardi 22 octobre 2019

Is there way to count the number of items in a row based on a criteria in one column?

So I am trying to figure out the formula for this. I've been trying to use COUNTIF and COUNTIFS functions but to no avail. I'm trying to count the number of occurrences for 30 minutes. It should show 1.

=COUNTIF(D7:D17,R7,E7:N10,"")

...where D7:D17 is the range in the first column and R7 is "30 minutes". E7:N10 is that range from 1-10 column. I get the error:

"Array arguments to COUNTIFS are of different size." Then I tried E10:N10 and still got the same error.)

[

Aucun commentaire:

Enregistrer un commentaire