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?

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?