ExcelBanter - Counta formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counta formula (https://www.excelbanter.com/excel-discussion-misc-queries/87970-counta-formula.html)

lla

Counta formula

When I enter the counta formula, it returns the formula rather than the
results. Why?

JMB

Counta formula

Check to see if your cell is formatted as text. If so, format as general,
then go to the cell w/your formula, click in the formula bar and hit enter.

"lla" wrote:

When I enter the counta formula, it returns the formula rather than the
results. Why?

All times are GMT +1. The time now is 01:20 AM.