Paddy1979
Well-known Member
- Joined
- Sep 23, 2005
- Messages
- 608
Hi folks,
Please can you help me with this formula.
I'm trying to sum every odd column and even column in a range with a condition that the team names match.
I have drew up an example of my issue. I hope its clear.
Many thanks.
Please can you help me with this formula.
I'm trying to sum every odd column and even column in a range with a condition that the team names match.
I have drew up an example of my issue. I hope its clear.
Many thanks.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | . | ||||||||
2 | Summary | ATotal | MTotal | ||||||
3 | TEAM1 | ||||||||
4 | Shouldbe | 120 | 51 | ||||||
5 | |||||||||
6 | |||||||||
7 | |||||||||
8 | P1A | P2M | P3A | P3M | P4A | P4M | |||
9 | TEAM1 | 22 | 21 | 10 | 8 | 88 | 22 | ||
10 | TEAM2 | 159 | 118 | 121 | 112 | 121 | 22 | ||
11 | TEAM3 | 160 | 119 | 122 | 113 | 122 | 23 | ||
Sheet1 |