How can I count the number of entries in a column of numbers?

I hope it's what you're looking for

Try to add a column C to that of the B values as in my example table 1

Then enter the formulas that I listed for you in the respective cells and...good luck

In B15      =COUNT(B)

In B16      =SUM(C)

In B17      =C$15÷B$15

in C2         =COUNTIF(B2;”>0”)

=COUNT()

Give it the range of cells you want to count.

COUNT() will return the number of text, number or date cells in the range. e.g. COUNT(B) will return the number of values in column B (excluding header and footer rows), or COUNT(A1:D5) to count all the cells in that range.

There are variations on COUNT(), too, such as COUNTA() which counts all non-blank cells (or COUNTBLANK() if you want to know how many are blank). There are also conditionals such as COUNTIF() which count how many cells in the range meet a criteria (e.g. equal/greater than/less than a value, contain a particular string, etc.)

> What I am wondering is if the formula can read the "<0" and make the result Red text.

I think that's what Dubbia was trying to show you.

At a high level, your formula cannot change the color of the cell. Formulas can only affect the values.

However, applying Conditional Formatting to the cell can change the appearance of the cell based on its values.

In other words, think of it as a two-step process:

Step 1 - Calculate the cell value (COUNT(), COUNTIF(), whatever)

Step 2 - apply Conditional Formatting to the cell that says "If the value of this cell is less than 0, then format at red text.

The two steps, combined, give you what I think you're aiming for.

For formatting select the column, or multiple columns, go to cell formatting and choose what you need  with the darts of the drop-down menu

For the color select the column always go to cell formatting and click on conditional highlighting.

Choose a number less than 0 then choose red text or one of the other possibilities that are listed 

of the drop-down menu

(The attached screenshot is in Italian)

@Dubbia I think you have your footer column/row labels switched.

C15 = SUM(C)

D15 = C$15/B$15

C15 could also be =COUNTIF(B, ">0) and eschew the whole column C

Thank you Camelot for correcting my mistakes and especially for explaining the various steps, which I didn't do, but I had to do.

You're right about column D (not C): it's useless if you put it in C15

=COUNTIF(B;">0")÷B$15