Pete,

If N/A was typed in and thus text, wouldn't SUM() ignore it anyway?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Pete_UK" wrote in message
oups.com...
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