Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding numbers with a label
I need to add the numbers with a label behind it. For instance in one row I have 0.5S in Cell E9, 0.5S in Cell G9 and 0.5V in Cell J9 and 0.5V in Cell L9. How do I get excel to know that Vacation time totals 1.0 and Sick time total 1.0. I can get this to calculate without the labels however, I need to differiate sick from vacation time. If this is not possible, do you have any other solution? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions | |||
Adding adjacent numbers and resettiing when encountering 0 | Excel Worksheet Functions | |||
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA | Excel Worksheet Functions | |||
Adding numbers to current numbers | Excel Worksheet Functions | |||
adding only positive numbers | Excel Discussion (Misc queries) |