Countif help!!!

  • Thread starter Thread starter bellis
  • Start date Start date
B

bellis

Thanks in advance for any help offered. I have a table with GPA's and
need to calculate the different ranges. I have the function for 3.0 an
above and less than 2.5. I am having trouble figuring out the formul
to count how many students are in the range of 2.50-2.99.

I thought I could do this:

=countif(f2:f406, ">=2.5+<=2.99")

I get "0" as a result.

any help is appreciated
:
 
Hi,

You can use Sumproduct...

=SUMPRODUCT(--(F2:F406>=2.5),--(F2:F406<=2.99))

Hope this helps
 
Hi Bellis!

Only one condition argument is allowed by COUNTIF and SUMIF but:

One way:

=COUNTIF(F2:F406, ">="&2.5)-COUNTIF(F2:F406,">"&2.99)

Another way:

=SUMPRODUCT(--((F2:F406)>=2.5),--((F2:F406)<=2.99))

The arguments are implicit IF statements that return TRUE or FALSE.
The -- is coercing those returns to 1 and 0. SUMPRODUCT is multiplying
the results together and adding the answers so that only if both
conditions are met will 1 be counted.
 
Hi Bellis..........

=COUNTIF(F2:F406,"<=2.99")-COUNTIF(F2:F406,"<2.5")

Vaya con Dios,
Chuck, CABGx3
 
It leaves out values that are either 2.5 or 2.99 (which appear should be
included)

Are you sure it worked great?
 
Back
Top