helper column with this idea
=SUBSTITUTE(SUBSTITUTE(E2,"L",""),"m","")
then try this array formula entered with ctrl+shift+enter
=SUM(VALUE(F2:F5))
--
Don Guillett
SalesAid Software

"Simon Lloyd"
wrote in message
...

Hi all, is it possible to sum cells that have both letters and figures
in?, i have lists of figures some of which look like this £3.5m, £5m
etc is it possible to write a formula which just sums the figures?

All help or suggestions appreciated.

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=571172