ExcelBanter - Function - counting based on criteria

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function - counting based on criteria (https://www.excelbanter.com/excel-worksheet-functions/84286-function-counting-based-criteria.html)

Candace

Function - counting based on criteria

I have a column of numbers. I need 3 formulas: (1) to count the numbers that
are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the
rows in the column that are blank. Any assistance would be greatly
appreciated. Thanks.

Duke Carey

Function - counting based on criteria

=countif(A1:A100,"<=60")
=countif(A1:A100,"60")
=countblank(A1:A100)

"Candace" wrote:

I have a column of numbers. I need 3 formulas: (1) to count the numbers that
are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the
rows in the column that are blank. Any assistance would be greatly
appreciated. Thanks.

Duke Carey

Function - counting based on criteria

Oops - the first formula ought to be one of these two

=sumprooduct(--(A1:A100<=60),--(A1:A100=1))
or
=countif(A1:A100,"<=60")-countif(A1:A100,"<1")

"Duke Carey" wrote:

=countif(A1:A100,"<=60")
=countif(A1:A100,"60")
=countblank(A1:A100)

"Candace" wrote:

I have a column of numbers. I need 3 formulas: (1) to count the numbers that
are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the
rows in the column that are blank. Any assistance would be greatly
appreciated. Thanks.

All times are GMT +1. The time now is 01:59 AM.