COUNTIF Fuction in Excel

[LJ]

Does anybody know how to use two criteria in the COUNTIF fuction. I
need to count cells if they contain numbers <# AND >=#. How do i use
this AND in the COUNTIF fuction? Any help would be great.

Thanks

 

[RagDyer]

In most cases, add the Countifs together.
For your case it might actually be a subtraction, depending on the criteria.

Or, you could use Sumproduct().

What's the arguments that you're looking to calculate?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Does anybody know how to use two criteria in the COUNTIF fuction. I
need to count cells if they contain numbers <# AND >=#. How do i use
this AND in the COUNTIF fuction? Any help would be great.

Thanks

 

[Juan Sanchez]

Not with countif but works:

=SUMPRODUCT((B1:B8<80)*(B1:B8>=20))

Will count the number of cells < 80 and >= 20

Cheers
JS

 

[Ron Rosenfeld]

Does anybody know how to use two criteria in the COUNTIF fuction. I
need to count cells if they contain numbers <# AND >=#. How do i use
this AND in the COUNTIF fuction? Any help would be great.

Thanks

=COUNTIF(cells, ">=#") - COUNTIF(cells, ">#")


--ron