counting

  • Thread starter Thread starter Soz
  • Start date Start date
S

Soz

Is there a countif (or other) statement that will count all numbers in a
column within a range ie everything between 400 & 499
 
Hi
some ways:
=COUNTIF(A1:A100,">=400")-COUNTIF(A1:A100,">499")

or
=SUMPRODUCT((A1:a100>=400)*(A1:A100<=499))

or
=SUMPRODUCT(--(A1:A100>=400),--(A1:A100<=499))
 

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

Countif help needed 6
CountIf with And 0
sumproduct for numeric range 3
Multiple arguments 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Excel Formula - Count Dates from another Sheet 8
count number of occurances between 2 values 2
COUNTIF Function with mulitple criteria? 6

Back
Top