ExcelBanter - Counting the number of formulas on a sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting the number of formulas on a sheet (https://www.excelbanter.com/excel-worksheet-functions/49965-counting-number-formulas-sheet.html)

Werner Rohrmoser

Counting the number of formulas on a sheet

Hello,

is there a formula, which I can use
to count the number of formulas on a sheet?

Werner
Excel XP SP2, WIN XP 5.1 SP1

Andy Brown

Werner Rohrmoser wrote:
Hello,

is there a formula, which I can use
to count the number of formulas on a sheet?

Werner
Excel XP SP2, WIN XP 5.1 SP1

No formula that I know of. Try F5 -- Special -- Formulas -- OK, then
switch AutoCalc to "Count" (rightclick the status bar).

HTH,
Andy

All times are GMT +1. The time now is 12:17 AM.