View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jaime.CIS Jaime.CIS is offline
external usenet poster
 
Posts: 2
Default 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).