Countif

J

Jo

H

I hope you can help. I want to count the number of cells that are >=500 and <=599 ie fall between these numbers in a column

Thanks in advance
 
F

Frank Kabel

Hi Jo
try
=SUMPRODUCT((A1:A100>=500)*(A1:A100<=599))

or as alternative syntax
=SUMPRODUCT(--(A1:A100>=500),--(A1:A100<=599))

or using two COUNTIF functions:
=COUNTIF(A1:A100,">=500")-COUNTIF(A1:A100,">599")
 

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

returning a value in a table referencing ranges 2
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Vlookup is adding quotes! 3
Using <= in countifs statement 1
Delete 100 Hundred Unique Values From Word Document 0
Mick & Clause & Experts Please help me on this issue one more time 13
Count Number of Unique Cells That Don't Have Certain Characters 0
SUMIF between date range 0

Top