View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cbuck
 
Posts: n/a
Default sum column containing both text and numbers

I need a formula that will sum a column that contains both text and numbers.
The text and numbers appear in this column as the result of an if formula (if
value returned 0, "-", [value]). Can I sum a column containing mixed
information?