problem with countif

C

Cowtoon

I'm wanting to count the number of cells that have a value between 10 and
12.1. The current range (before I add any more is F2:F19.

Can anyone see what's wrong with this formula. I'm stumped and it's
probably sooooo simple. Fortunately, the sample is small enough to see that
the results are wrong. Correct result is 3, however, it generates a result
of 11. Can someone help. Please and thanks.

=COUNTIF(F2:F19,"<12.1")-COUNTIF(F2:F19,">10")

The data in the range is:
9
3
3
5
15
10
1
8
7
8
11
12
10
0
2
12
1
6
 
F

Frank Kabel

Hi
try:
=COUNTIF(F2:F19,"<12.1")-COUNTIF(F2:F19,"<=10")
if 12.1 and 10 both should be excluded
 
C

Cowtoon

This is what I ended up using.
Thank you all for your help.
One of you posted this formula. Thanks.
Diana

=COUNTIF(G2:G16,"<12.1")-COUNTIF(G2:G16,"<=10")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the weighted average of text that have been given values 1
Need help with sorting and moving to worksheets 1
Countifs or a pivot 1
Countif with dates for vs 2003 8
Can these countif functions all be combined in one cell? 6
Countif between Time stamps and have - value 0
If Function 1
Countifs with different restrictions 1

Top