WHICH COUNT FUNCTION?

  • Thread starter Thread starter Johnny1r
  • Start date Start date
J

Johnny1r

Hello and thank you for looking at my problem. I have a column of
numbers say 1 to 100 (A:1 to A:100) and I want to count the number of
cells in that range that are between 30 and 50 and including 30 and 50
(count should be 21). I've tried most count functions but can't seem to
come up with the right formula. Can someone please help. Thanks John
:)
 
Use to COUNTIFs...

=COUNTIF(A1:A100,"<=50")-COUNTIF(A1:A100,"<30")

Notice the logical operators... the one in front of the 50 has the equal
sign because we want to count the 50, the second one omits the equal sign
because it is what is being subtracted and we do not want to subtract the
30.

Rick
 
Use to COUNTIFs...

"to"???? LOL... Of, course, that should have been "two".

Rick
 

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

How do I count once, multiple duplicate values? 1
Excel Formula - Count Dates from another Sheet 8
Count and Sum functions with 2 criterias 20
Excel VBA - counting cells by colors and names to it in two different rows. 0
Countifs with different restrictions 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Count function without double counting 1
If with countif or counta 3

Back
Top