CODEWITHSUNDEEP
xls
user3191465
user3191465

Reputation: 13

how to count from 2 columns with different criteria in 1 column

I hope that someone can help me get the correct formula for the following:

My data is as follows:

  C           G
 GRADE  |  COUNT/LB
 ------------------
 MINI   |    15
 MINI   |    20
 MINI   |    37
 MINI   |    39
 MINI   |    50

What I want is to count only the MINIs from column C that have a count of less than 36 and greater than 46, which in this case would be 3.

I have tried: =countifs(c3:c7,"mini",g3:g7,"<36")+countifs(c3:c7,"mini",g3:g7,">46" and I get a count of 0; I have also tried, =count(c3:c7,"mini")+sum(countif(g3:g7,{"<36,">46"})) and get a total of 5

Any help would be greatly appreciated.

Upvotes: 1

Views: 38

Answers (1)

Fred
Fred

Reputation: 4221

The code =countifs(c3:c7,"mini",g3:g7,"<36")+countifs(c3:c7,"mini",g3:g7,">46" works out of the box for me, maybe you typed it wrong?

Upvotes: 1

Related Questions