Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to add cells WITH numbers but they have letters
(alphanumerical). Example: A B C D E Total of sick days (S) Total vacations (L) L2.3 S3 W L3.3 - ..... 3 5.5 L1.2 - - - - 1.2 I'd like to sum just numbers of previous cells of A to E and total them at the last columns. By the way, if conditional formula may concider like the W letter but with a specific value like 7.2 and add it to a previos total. The same for S and L. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Cells with a letter in one of them | Excel Discussion (Misc queries) | |||
Summing all cells containing the letter K | Excel Worksheet Functions | |||
Formula for cells that contain a specific letter | Excel Worksheet Functions | |||
How can I add a two letter prefix to text in cells? | Excel Discussion (Misc queries) | |||
count cells in a coloumn with letter x in it | Excel Worksheet Functions |