1st offering should have been -7. This also works.
=SUM(IF(LEFT(E2:E10,5)="Total",VALUE(RIGHT(E2:E10, LEN(E2:E10)-7))))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Try this ARRAY formula that must be entered using ctrl+shift+enter
=SUM(IF(E2:E10<"",VALUE(MID(E2:E10,8,LEN(E2:E10)-8))))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"brett" wrote in message
ps.com...
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.