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.

"Mike H." wrote:

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

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.

"Mike H." wrote:

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

Sometimes when I select the specialformulas 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?

"Soundar" wrote:

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.

"Mike H." wrote:

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

If any error in selected cells, then it will not display SUM in status bar.

Regards,
Soundar.

"Mike H." wrote:

Sometimes when I select the specialformulas 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?

"Soundar" wrote:

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.

"Mike H." wrote:

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