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.