Formula wildcards

[Boenerge]

Hi,
In the following formula the "*" I thought was a wildcard character. I am
using the cell to report a percentage. I want the "*" to count anything that
has been placed in a cell e.g. a date or NA or 0.
Can anyone help with the formula?
Thanks in advance
Jason





=COUNTIF(D642,"*")/ROWS(D642)

 

[Peo Sjoblom]

It counts text only

replace the countif part by this

=COUNTA(D642)


--


Regards,


Peo Sjoblom

 

[T. Valko]

In the following formula the "*" I thought was a wildcard character.

=COUNTIF(D642,"*")/ROWS(D642)

It is a wildcard but it only represents *text* entries.

Try this:

=COUNTA(D642)/ROWS(D642)