Sum Range Moving Reference Target

[Bkisley]

I have sales by platform by month in a table
Let's say I have the following
Cell A1 = dropdown with all the months of the year
Cell A5 = Platform
Cells A6:A20 are the different platforms
Cell B5:M5 are the months of the year
Then cells B6:M20 is the sales by platform by month

What I need to do is come up with an equation (let's put it in cell N6, N7.....N20) that will do the sum range of each platform per the month I choose

So I select May in the dropdown in cell A1 in cell N6 I need to take the sum of January through May for that one platform.

I know I can do this with a very long if statement, but I don't want that. There has to be a better way

May is the 5th month so if I select May then sum the first 5 cells to the right or something like that??

 

[Marcelo Branco]

Maybe...

N6 copied down
=SUM(B6:INDEX(B6:M6,MATCH(A$1,B$5:M$5,0)))

Hope this helps

M.

 

[Bkisley]

Worked PERFECTLY!

Thank you!

Maybe...

N6 copied down
=SUM(B6:INDEX(B6:M6,MATCH(A$1,B$5:M$5,0)))

Hope this helps

M.

 

[Marcelo Branco]

You're welcome. Thanks for the feedback.

M.