sum of column with #n/a in some fields
 

How do I calculate the sum of a column when some fields have the #n/a error
display. I have hidden those fields for printing, but I'm unable to sum up
the column without filling in or deleting those rows (which I do not want to
do).

sum of column with #n/a in some fields
 

Hi!

Try this:

=SUMIF(A1:A10,"<#N/A")

Biff

"Jaime.CIS" wrote in message
...
How do I calculate the sum of a column when some fields have the #n/a
error
display. I have hidden those fields for printing, but I'm unable to sum
up
the column without filling in or deleting those rows (which I do not want
to
do).