Mamarazzi
asked on
Finding accumulated sum in grid
I have a grid with key values in left column and top row and I want to accumulate the values in the grid dynamically.
See attached file!
I want the formula to find the right row using values in Col B and then give me the sum of all values on that row beginning with Col C and ending in a column using values in row 2.
I was thinking sum combined with vlookup but I didn't get that to work. I am using excel 2003 now.
grid-example.xls
See attached file!
I want the formula to find the right row using values in Col B and then give me the sum of all values on that row beginning with Col C and ending in a column using values in row 2.
I was thinking sum combined with vlookup but I didn't get that to work. I am using excel 2003 now.
grid-example.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER