Statistics

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to see:
1. The number of cells with formulas in a spreadsheet
2. The number of cells with values
3. The number of cells with text
 
Maybe try edit|goto|special|formulas or constants and right-click the status
bar to show "count".

To select all non-blank cells, you can select a blank column to the right of
the data then drag back to the first column and choose
edit|goto|special|column differences.
 
Hi Mike,

1) The number of cells with formulas in a spreadsheet

You can check this as follows:

Edit --> Go to --> special --> Choose formula and then click OK, it will
highlight the cells which contains formulas. (If you want to count the cells
with formula, you can right click in status bar (right end) and then give
count).

2) The number of cells with values

=COUNT(range) --> will give you the number of cells contains numeric values.

3) The number of cells with text

=COUNTIF(range,"*") --> Will give you the number of cells which contains
text.

Hope this will clear your doubt.

Regards,
Soundar.
 
Sometimes when I select the special>formulas and then right-click the status
bar and select count, nothing is displayed. Actually nothing is displayed
for sum, average, or any of the options. Is this because perhaps there is an
error in one of the selected cells?
 
If any error in selected cells, then it will not display SUM in status bar.

Regards,
Soundar.
 
Back
Top