How can make a formula to add add the nominators and denominators

T

thrower4life

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?
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
How can the font and size of (all) citation numbers be altered? 1
Insert Index into a Table 1
Add time when working 3rd shift 0
formula issues. 0
Subtraction from the lowest number postion wise in Column 3
Changing Numerators but not Denominators 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0

Top