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
MamarazziAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
barry houdiniConnect With a Mentor Commented:
Say you have input values in J2 and K2, for the column B and row 2 values respectively then you can use this formula

=SUM(OFFSET(INDEX(C$3:F$7,MATCH(J2,B$3:B$7,0),0),0,0,1,MATCH(K2,C$2:F$2,0)))

see attached

regards, barry
grid-example-barry.xls
0
 
MamarazziAuthor Commented:
That works just fine! Thanks a lot, Mr Houdini :-)
0
All Courses

From novice to tech pro — start learning today.