| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to count
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count
"computexcel" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count
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. "Tradesman" wrote: "computexcel" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count
Use this formula
=COUNTIF(A1:A255,"65") "computexcel" wrote: 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. "Tradesman" wrote: "computexcel" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count
Hello my VISTA friend.
I figured it out this formula but without the quotation mark in it. Thanks again for rescueing me. "Sheeloo" wrote: Use this formula =COUNTIF(A1:A255,"65") "computexcel" wrote: 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. "Tradesman" wrote: "computexcel" wrote: 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count
:-)
Hope we will be Excel 2007 friends soon... "computexcel" wrote: Hello my VISTA friend. I figured it out this formula but without the quotation mark in it. Thanks again for rescueing me. "Sheeloo" wrote: Use this formula =COUNTIF(A1:A255,"65") "computexcel" wrote: 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. "Tradesman" wrote: "computexcel" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Formula - Count Ticks | Excel Discussion (Misc queries) | |||
| Count formula | Excel Discussion (Misc queries) | |||
| Trying to construct a count count formula | Excel Discussion (Misc queries) | |||
| Count formula Help... | Excel Discussion (Misc queries) | |||
| Count down formula | Excel Worksheet Functions | |||
Linear Mode
