View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fyrfytr Fyrfytr is offline
external usenet poster
 
Posts: 2
Default adding numbers that contain ranges

I would like to add a column of numbers, but some of the cells contain a
range ($800 - $1000) in them. Is there a formula / function, or do I need to
split up the ranges.