| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing figures within letters???
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a Worksheet using Capital letters | Excel Worksheet Functions | |||
| Excel formula for summing using figures from adjoining rows | Excel Worksheet Functions | |||
| Replacing letters for figures in formula | Excel Discussion (Misc queries) | |||
| summing up figures | Excel Discussion (Misc queries) | |||
| Calculate minus figures only | Excel Discussion (Misc queries) | |||
Threaded Mode
