ExcelBanter - counts

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

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

- - counts (https://www.excelbanter.com/excel-discussion-misc-queries/188648-counts.html)

Arvind Mahto

counts

Can i pull out the count of more than 1000 out of a range of numbers?
Please help...

Mike H

counts

Hi,

Try this but be careful, if there are dates in the range because dates in
Excel are numbers then they could also be counted.

=COUNTIF(A1:A20,"1000")

Mike

"Arvind Mahto" wrote:

Can i pull out the count of more than 1000 out of a range of numbers?
Please help...

Pete_UK

counts

Try this:

=COUNTIF(A:A,"1000")

assuming your numbers are in column A.

Hope this helps.

Pete

On May 23, 3:22*pm, Arvind Mahto
wrote:
Can i pull out the count of more than 1000 out of a range of numbers?
Please help...

JE McGimpsey

counts

If I understand you correctly:

=COUNTIF(range, "1000")

In article ,
Arvind Mahto wrote:

Can i pull out the count of more than 1000 out of a range of numbers?
Please help...

All times are GMT +1. The time now is 06:50 PM.