I am a novice Excel user and just want to total a column based on the number of entries - not add up the numbers in the cells. I just need a count of how many entries I have made.
2007-02-15 11:05:44 · 3 answers · asked by Your Mom 6 in Computers & Internet ➔ Software
=COUNT(C4:C12) That is what you need. Of course change the cell numbers to what your cell numbers are.
2007-02-15 11:15:45 · answer #1 · answered by Anonymous · 1⤊ 0⤋
Select the columns the data is entered on, At the status tool bar, where 'Steady' and 'Num' is, you will see the default 'SUM". Rightclick, change it to "Count". Now you know how many entries you made without adding a single formula.
2007-02-15 13:25:57 · answer #2 · answered by unnga 6 · 0⤊ 0⤋
the function is "count" , put it in an ajacent cell and it will ask you for the data range.
2007-02-15 11:15:21 · answer #3 · answered by THE ONE 6 · 0⤊ 0⤋