software

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.

=countif(A1:A100,quot;lt;=60quot;)
=countif(A1:A100,quot;gt;60quot;)
=countblank(A1:A100)

quot;Candacequot; wrote:

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

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

=sumprooduct(--(A1:A100lt;=60),--(A1:A100gt;=1))
or
=countif(A1:A100,quot;lt;=60quot;)-countif(A1:A100,quot;lt;1quot;)quot;Duke Careyquot; wrote:

gt; =countif(A1:A100,quot;lt;=60quot;)
gt; =countif(A1:A100,quot;gt;60quot;)
gt; =countblank(A1:A100)
gt;
gt; quot;Candacequot; wrote:
gt;
gt; gt; I have a column of numbers. I need 3 formulas: (1) to count the numbers that
gt; gt; are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the
gt; gt; rows in the column that are blank. Any assistance would be greatly
gt; gt; appreciated. Thanks.