View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brett brett is offline
external usenet poster
 
Posts: 7
Default Summing columns that contain letters

I have a colunm that I want to sum. The problem is that each entry
looks like this:

Total: 80.60
Total: 95.00
Total: 84.75

The SUM() function doesn't work on those. How else can I do it?

Thanks.