Lookup and sum across columns

[JV0710]

Hi All

Please can I have some help wityh the folowing query:

As seen in the picture below, In cell D2, I want to:

Go to the column = to value in A2, and the row = value in B2.
Then from that point sum 3.6 columns across.

The value I am looking for in Cell D2 is 15.6 ==> " sum(g8:I8)+(j8*0.6) "

I require a formula to calculate this value please

Thanks

JVN

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	w2	Harry	3.6	15.6
3
4						w1	w2	w3	w4	w5	w6	w7
5					John	5	6	5	7	9	4	5
6					Mary	6	5	4	7	8	7	3
7					Jane	7	4	3	7	7	12	5
8					Harry	8	3	2	7	6	13	6
9					Joe	9	2	1	7	5	16	5
10					Carol	10	1	4	7	4	19	7
11					Sue	11	3	6	7	3	22	8
12					Kevin	12	8	5	7	2	25	5
13					Steve	13	6	7	7	8	28	4
14					Len	14	7	8	7	5	31	11
15					Alice	15	8	3	7	6	34	8
16					Ian	16	9	8	7	7	37	9
17
Sheet1

 

[Andrew Poulsom]

One way:

=SUM(OFFSET(E4,MATCH(B2,E4:E16,FALSE)-1,MATCH(A2,E4:L4,FALSE)-1,1,3),(OFFSET(E4,MATCH(B2,E4:E16,FALSE)-1,MATCH(A2,E4:L4,FALSE)+2)*0.6))

 

[Jonmo1]

Here's Andrew's formula, but using the value in C2 to create the 3 and the .6
which is what I think you wanted...

=SUM(OFFSET($E$4,MATCH(B2,$E$5:$E$16,0),MATCH(A2,$F$4:$L$4,0),1,C2))+(OFFSET($E$4,MATCH(B2,$E$5:$E$16,0),MATCH(A2,$F$4:$L$4,0)+C2)*MOD(C2,1))

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1
2	w2	Harry	3.6	15.6
3
4						w1	w2	w3	w4	w5	w6	w7
5					John	5	6	5	7	9	4	5
6					Mary	6	5	4	7	8	7	3
7					Jane	7	4	3	7	7	12	5
8					Harry	8	3	2	7	6	13	6
9					Joe	9	2	1	7	5	16	5
10					Carol	10	1	4	7	4	19	7
11					Sue	11	3	6	7	3	22	8
12					Kevin	12	8	5	7	2	25	5
13					Steve	13	6	7	7	8	28	4
14					Len	14	7	8	7	5	31	11
15					Alice	15	8	3	7	6	34	8
16					Ian	16	9	8	7	7	37	9
Sheet1

 

[JV0710]

Thank You Guys

That works perfectly

Joe