Adding numerator and denominator in same cell

[dsacomano]

Not sure if this is possible, but I am looking to add both the numerator and denominators and total them in a final cell. It is to track individual phone calls answered vs total phone calls received from a call center.

Example.

B2- 74/326 (74 answered, 326 total calls)
C2- 55/245
D2- 81/195

I am hoping to add these so that E2 will show 210/766.

Any help would be greatly appreciated. Thanks.

 

[Fluff]

Hi & welcome to MrExcel.
How about

Book1
	B	C	D	E
2	74/326	55/245	81/195	210/766
Request

Cell Formulas
Range	Formula
E2	{=SUM(--LEFT(B2:D2,FIND("/",B2:D2)-1))&"/"&SUM(--MID(B2:D2,FIND("/",B2:D2)+1,100))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[dsacomano]

When I use Ctrl+Shift+Enter to enter this formula, it doesn't give me the brackets. I have tried copying and pasting and typing the formula manually.

 

[Fluff]

Enter the formula without the {} & whilst in Edit mode hit Ctrl Shift Enter

 

[Rick Rothstein]

Hi & welcome to MrExcel.
How about

Book1
	B	C	D	E
2	74/326	55/245	81/195	210/766
Request

Cell Formulas
Range	Formula
E2	{=SUM(--LEFT(B2:D2,FIND("/",B2:D2)-1))&"/"&SUM(--MID(B2:D2,FIND("/",B2:D2)+1,100))}
Press CTRL+SHIFT+ENTER to enter array formulas.

For those uncomfortable with array-entered formulas, you can turn Fluff's array-entered formula into a normally-entered formula by using SUMPRODUCT instead of SUM function calls...

=SUMPRODUCT(--LEFT(B2:D2,FIND("/",B2:D2)-1))&"/"&SUMPRODUCT(--MID(B2:D2,FIND("/",B2:D2)+1,100))

 

[Fluff]

Excellent point Rick.
Thanks for that.

 

[dsacomano]

Thank you Rick, this worked!