Formula to count

  • Thread starter Thread starter computexcel
  • Start date Start date
C

computexcel

A1 to A255 has numbers.
I'like to have in A256 the total of number over 65 in that range.
NOT SUM, but how many numbers are over 65.
Thanks for your patience.
 
computexcel said:
A1 to A255 has numbers.
I'like to have in A256 the total of number over 65 in that range.
NOT SUM, but how many numbers are over 65.
Thanks for your patience.
Click to expand...
 
Hi, tradesman, thanks for trying, but for some reason I can not see any text
in your answer, if you kindly could repeat it. Thanks.
 
Use this formula
=COUNTIF(A1:A255,">65")

computexcel said:
Hi, tradesman, thanks for trying, but for some reason I can not see any text
in your answer, if you kindly could repeat it. Thanks.
Click to expand...
 
Hello my VISTA friend.
I figured it out this formula but without the quotation mark in it.
Thanks again for rescueing me.
 
:-)

Hope we will be Excel 2007 friends soon...

computexcel said:
Hello my VISTA friend.
I figured it out this formula but without the quotation mark in it.
Thanks again for rescueing me.
Click to expand...
 
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

COUNTIF Cells in Range? 4
converting formula for whole numbers to time 3
Sumproduct 9
Combo Box and VLOOKUP 7
How to count date difference in excel? 5
SUM with multiple + and - 4
Help creating a formula 8
Excel Need Countifs Formula Help 0

Back
Top