| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add cells including text
Hi, I have a row of cells. as below: Hol 8.00 9.75 9.00 Hol 8.00 10 9.25 9.00 8.25 I want to add the numerical elements in this row, but the text parts are causing an error. Is there a forumula that will only add the numerical parts, without resorting to nested IF statements saying IF(cell="Hol") etc etc? Thanks in advance -- HappyTrucker ------------------------------------------------------------------------ HappyTrucker's Profile: http://www.excelforum.com/member.php...o&userid=25997 View this thread: http://www.excelforum.com/showthread...hreadid=395644 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup on large text in cells | Excel Worksheet Functions | |||
| Large amount of text in cells - Problem text.xls (0/1) | Excel Discussion (Misc queries) | |||
| Format text across cells | New Users to Excel | |||
| how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
| how do I 'count' the number of cells with a text in red or black? | Excel Worksheet Functions | |||
Threaded Mode
