Hi there, i am trying to figure how to write a formula so that if one cell says a certain word, it will take the data from a certain cell within that row. For example;

A1 - Football
B1 - Tennis
C1 - Football
D1 - Tennis

A7 - 14
B7 - 6
C7 - 6
D1 - 5

So, on a summary sheet it would pick up;
Football 2
Total - 20

Hope that makes sense

Thanks