=SUMIF(G1:G11,"<#N/A",G1:G11)

But it is FAR better to deal with the #N/A error at source:

=IF(ISNA(<your formula),"",<your formula)

--
HTH

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


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


"Adam" wrote in message
...
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