Thread: Adding fractions in excel

Hi All,

I'm trying to sum fractions (#/#) to get an overall percentage, and am having some trouble with it.

Here's a quick example:



Row 1 2006 2007 2008 2009 | (desired outcome)

Row 2 0/1 0/0 1/1 0/1 | 1/3

Row 3 0/0 0/0 0/0 0/1 | 0/1

Row 4 1/1 1/1 1/1 1/1 | 4/4

Row 5 0/1 0/1 0/1 0/1 | 0/4


Basically, I am trying to calculate participation (numerator) over whether they had the opportunity to participate (denominator). The column above, "desired outcome" is what I want these fractions to add up as (but am currently having trouble with). Basically, I would like to separately sum both numerators and denominators as an aggregate fraction (percentage would work, too). Similar to a basketball player's shooting percentage over the course of different games. The COUNT and SUM functions have been useless thus far.

Thanks!!

Awesome. That formula works, but I'm still having problems with my cells that have values "1/1" They are only returning "1" and it is giving me a value error with the function that you gave me. Any help on this issue? I think excel automatically formats "1/1" as "1" and it is giving my formula an error.

got it figured out by using the =TEXT(A2, "#/#") function to convert all fractions.