Countif

A

AnnC

How do I count the number of cells that contain values within a range, e.g. =countif(A1:A1000, ">=16 and <25) - All the cells that contain a number less than or equal to 16 and
 
F

Frank Kabel

Hi
try
=SUMPRODUCT((A1:A1000>=16)*(A1:A1000<25))

or as alternative syntax
=SUMPRODUCT(--(A1:A1000>=16),--(A1:A1000<25))
 
Top