| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can make a formula to add add the nominators and denominators
I am trying to set up a worksheet to tally the number of actual
attendance/number of possible sessions to attend. I want to keep the two numbers in one box. So, data is entered as follows: 11/22, 12/12, 15/20 and so on. I want to make a formula that will add all the top numbers together and then the bottom numbers together and put the answer in one cell. (I hope that all made sense!) Can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can make a formula to add add the nominators and denominators
Assuming there are no empty cells:
=SUMPRODUCT(LEFT(A1:A3,FIND("/",A1:A3)-1)+0)&"/"&SUMPRODUCT(MID(A1:A3,FIND("/",A1:A3)+1,20)+0) -- Biff Microsoft Excel MVP "thrower4life" wrote in message ... I am trying to set up a worksheet to tally the number of actual attendance/number of possible sessions to attend. I want to keep the two numbers in one box. So, data is entered as follows: 11/22, 12/12, 15/20 and so on. I want to make a formula that will add all the top numbers together and then the bottom numbers together and put the answer in one cell. (I hope that all made sense!) Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to divide a number into various denominators | Excel Worksheet Functions | |||
| 12ths denominators for fractions in Excel (for pension calcs) | Excel Worksheet Functions | |||
| How do I make a formula read a result rather than a formula | Excel Discussion (Misc queries) | |||
| I'd like to make a formula that does this.. | Excel Worksheet Functions | |||
| how do I make My formula bar appear | Excel Discussion (Misc queries) | |||
Hybrid Mode
