Counting # of cells

  • Thread starter Thread starter Ronnie
  • Start date Start date
R

Ronnie

I need a formula to count the number of cells in a column that contain the
numbers between 120 and 129. Thanks for any input!
 
=COUNTIF(A1:A100, ">=120") - COUNTIF(A1:A100, "<=129")
or
=SUMPRODUCT(--(A1:A100>=120),--(A1:A100<=129))
best wishes
 
the column being 'A', it could be written this way:

=COUNTIF(A:A,"<130")-COUNTIF(A:A,"<120")
 
I think you mistyped on your COUNTIF
I believe it should be:
=COUNTIF(A1:A100, ">=120") - COUNTIF(A1:A100, ">129")
 
I am so close, but it's not working. I think it's the minus sign in the
formula. Any other suggestions.
 
I'm not sure what was wrong. I was unable to get the counts to come out
properly. I did get the "sumproduct" formula to work. I would like to know
why the other formula was not working, but it wasn't.
 
You must log in or register to reply here.

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

Counting number of items excluding duplicates. 1
COUNT function - # of occurences a number appears in all cells 26
copy formulas over merged cells 2
counting dates using SUMPRODUCT 4
Count number of inputs 2
Count Formula Need Help! 1
Count until condition is met and then retain final count 2
Count Dates & Return as % 2

Back
Top