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))
 

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

COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Excel Countif Function - Calculating Between Two Sets of Values 3
countifs Function not giving desired result with date criteria 2
Using <= in countifs statement 1
Calculate average in intervals 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Countifs with different restrictions 1
Multiple arguments 3

Top