View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
steve_sr2
 
Posts: n/a
Default How do I sum a range of data (column) that has #num! in some cells

I have columns of data that I need to sum. Some of these cells have #NUM! in
them. How would I sum these columns?

Thanks in advance for your ideas...