Count if cell between range and text status

[tlai34]

Hi,

I want a formula to count when a number is between a range and another column has the appropriate text.

It will be similar to =COUNTIFS(I10:I328, "H = High ", L10:L328, "Closed") except where I10:I328, "H = High " is a number range instead.

I tried =COUNTIFS($F$11:$F$96,">=1",$F$11:$F$96,"<=6", K11:K329, "Open") but it doesn't seem to work.

I also have conditional formatting on the F column if it would help.

The number range is from
1-6 = red
7-20 = orange
21-25 = green

 

[Aladin Akyurek]

The rages you feed to COUNTIFS are unequal... Try to adjust to the correct size:

=COUNTIFS($F$11:$F$96,">=1",$F$11:$F$96,"<=6", $K$11:$K$96, "Open")

 

[tlai34]

Didn't know this was a requirement, all goood!

 

[Aladin Akyurek]

Didn't know this was a requirement, all goood!

You are welcome. Thanks for the update.