Maybe this?
A B C D 1Year teams Finished % 2 2013 10 10 0% 3 2012 9 7 22% 4 2011 8 4 50% 5 27 21 22%
Jeff askedI dont see any samples in your reply to him?Can you give a couple of examples where you also tell us the resulting percentage that you expect?
D2=(B2-C2)/B2 copied down
B5=SUM(B2:B4) copied to C5
It is not a good idea to take an average of percentages, that is the same as taking an everage of averages...mathematically incorrect. I summed the 2 columns and used the same formula from above
Bookmarks