Formula to count

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.
 
T

Tradesman

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...
 
C

computexcel

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.
 
S

Sheeloo

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...
 
C

computexcel

Hello my VISTA friend.
I figured it out this formula but without the quotation mark in it.
Thanks again for rescueing me.
 
S

Sheeloo

:)

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...
 
Top