ExcelBanter - Formula to count

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to count (https://www.excelbanter.com/excel-discussion-misc-queries/202491-formula-count.html)

computexcel

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.

Tradesman

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.

computexcel

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.

Sheeloo

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.

computexcel

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.

Sheeloo

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.

All times are GMT +1. The time now is 02:52 PM.