Countif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 
Back
Top