Count cells which have ONLY FORMULAS

[welchs101]

Lets suppose i have 5 columns of data. 3 of the cols have "formulas" in them and 2 do not. I want to count the number of formulas that are in a given row. Is there a way to do this?

Dave

[shg]

Please Login or Register  to view this content.

[welchs101]

Thanks for your help. Based onyour input i came up with the following:

Please Login or Register  to view this content.

The above counts the "formulas" in row 2.

Thanks.

[shg]

Good job, you're welcome.

Just be aware that SpecialCells with raise a run-time error error if no such cells exist.