Nested Sumif and Index Functions in Excel

[sanits591]

Hi

I am trying to make certain calculations using the available data, which is as:

Available Data

Sheet 1
a3:L12 = Data with numeric values - months from Jan, Feb,... Dec
n3:y12 = Name of Team members to be punched as desired, Jan, Feb, ... Dec, names from the list of Sheet 2 in the range a3:a12

Sheet 2
a3:a12 = Name of Team Members

Required using Excel functions

Sheet 2
b3:b12 = Sum of Values against each name of a3:a12 range from a3:L12 from sheet 1, with the same row falling in the range sheet 1 range n3:y12 (having desired names from list) picking and sum up the data from the corresponding range from sheet 1 range a3:L12.

I am unable to get it, how this nested function will work with this range, request to help in calculating with excel formula.

Thanks

 

[Brettster]

That's a bit confusing. Can you please provide an example?
Thanks.

 

[sanits591]

Thanks for looking at it! I am enclosing a link to the file.

https://www.box.com/s/1zpag4p30b2o5u6y9h6o

Thanks!

 

[sanits591]

Thanks for assistance, i got it resolved using:

b3=SUMIF(Sheet1!$N$3:$Y$12,$A3,INDEX(Sheet1!$A$3:$L$12,0,B$1)) and drag it down till b12.

Thanks for having a look at it.