=SUMIF(I1:I5,"<#N/A")

To remove #N/A you need something like:

=IF(ISNA(myformula),"",myformula)

HTH

"Jules73" wrote:

I have a list of products on drop downs (validation) which also populates a
cell next to it with its base cost. However if nothing is selected it shows
as #N/A. At the bottom of the list is a subtotal which works if it only looks
at cells with numbers. If it see an #N/A it doesnt total the ones that have
been populated. How can I get the subtotal to ignore blanks or #N/A? How do I
get it to show Blanks in stead of #N/A for that matter?

Thanks in advance.