Counting cells that do not contain N/A
If N/A has been typed in (rather than the error #N/A), then try this:
=COUNTIF(A1:A100,"<N/A")
Hope this helps.
Pete
On Oct 29, 10:41 am, Adam wrote:
Please could someone provide me with a formula that would allow me to count
the number of cells that do not contain N/A as an entry.
Thanks
Adam
|