L
Leanne at Work
Hello,
I think I might have better luck trying to explain myself by providing an
example first.
I have the following data:
A B C D E F G
1 Wk1 Wk2 Wk3 Wk4 Wk5 Wk6
2 REP 1.2007 1.2007 1.2007 2.2007 2.2007 2.2007
2 John 5 5 3 5 6
3 John 2 1 5 8 7
4 Jack 2 6 1 2
I am trying to create a formula in another spreadsheet that will sum the
total months (1.2007 etc) for the respective Reps. So for 1.2007, John will
have the total of 16 and Jack will have 8. For 2.2007 John will have a total
of 31 and so on.
The data I'm working with has varying duplicate row and column entries of
Reps and months - and these are likely to change as the data is refreshed.
Does anyone possibly know of a formula that will provide this data?
Thank you very much for your time.
I think I might have better luck trying to explain myself by providing an
example first.
I have the following data:
A B C D E F G
1 Wk1 Wk2 Wk3 Wk4 Wk5 Wk6
2 REP 1.2007 1.2007 1.2007 2.2007 2.2007 2.2007
2 John 5 5 3 5 6
3 John 2 1 5 8 7
4 Jack 2 6 1 2
I am trying to create a formula in another spreadsheet that will sum the
total months (1.2007 etc) for the respective Reps. So for 1.2007, John will
have the total of 16 and Jack will have 8. For 2.2007 John will have a total
of 31 and so on.
The data I'm working with has varying duplicate row and column entries of
Reps and months - and these are likely to change as the data is refreshed.
Does anyone possibly know of a formula that will provide this data?
Thank you very much for your time.