slamanager
Board Regular
- Joined
- Apr 20, 2007
- Messages
- 129
Hi,
can someone give me an example of a Index and Match to look at a table and give me the sum of the values.
col A contains the numbers (a4:a9)
1
2
3
1
2
3
B3 has the value "A" C3 has "B" up to G3 which has "F"
this matrix is populated with numbers its actually a pivot table pasted as values for 2 days three lines per day, i'm trying to build a formula matrix to total up all the values for the row and column inputs.
sum all the 1's in col B if the header is "A" the data is varible each day and i can get up to 100 unique returns and maybe not for each column.
Thanks
A,B,C,D,E,F
1 10,22,33,22,1,7
2 8,9,7,6,8,9
3 2,3,4,5,1,1
1 22,44,33,22,11,2
2 66,44,22,11,88,99
3 2,5,6,7,8,9
A/1 = 32
B/1 = 66
can someone give me an example of a Index and Match to look at a table and give me the sum of the values.
col A contains the numbers (a4:a9)
1
2
3
1
2
3
B3 has the value "A" C3 has "B" up to G3 which has "F"
this matrix is populated with numbers its actually a pivot table pasted as values for 2 days three lines per day, i'm trying to build a formula matrix to total up all the values for the row and column inputs.
sum all the 1's in col B if the header is "A" the data is varible each day and i can get up to 100 unique returns and maybe not for each column.
Thanks
A,B,C,D,E,F
1 10,22,33,22,1,7
2 8,9,7,6,8,9
3 2,3,4,5,1,1
1 22,44,33,22,11,2
2 66,44,22,11,88,99
3 2,5,6,7,8,9
A/1 = 32
B/1 = 66