How to shift a sum range from one column to another depending on Month?

Hi,

I have one sheet that looks like this:

January February March April Etc..
##### #### ### ### ##
##### #### ### ### ##
##### #### ### ### ##
##### #### ### ### ##
##### #### ### ### ##

The above picture shows that the first row in each column is a month and under each month there are numbers.

Now I have a 2nd sheet with a highlighted cell where I type in the month I want. I want another cell to SUM the first the numbers under each month DEPENDING on the month I type in my highlighted cell.

For example, if I type January, then I want only the sum of the first three numbers under january. If i type april then i only want the sum of the first three numbers under april.

Is this possible?

Thanks,

I am not allowed to use a pivot table Please help!

Hi Fotis1991,

The formula did not work. It says #Value!

1st sheet.PNGSheet 2.PNGpic 3.PNG

The first picture is sheet 1, second one is sheet 2, and the 3rd pic is the formula i am using based on ur reply.

Thanks!

Hi,

I figured it out! Thank you for your help!

This was the solution:

=+SUM(INDEX(Sheet1!C4:N15,0,MATCH(Sheet2$C$10,months,0)))