how to calculate YTD with 2 criterias

[mart_mrexcel]

how to calculate YTD with 2 criterias (i.e. heading is the month from B1 to M1 and Specific Code in the column A2 TO A10)

Example
A2 – A10 has name of the fruits
B1 to M1 has Jan to Dec
Each fruit has a value from Jan – Dec entered in B2 – M10

I want to get the YTD total of fruit if I type in the name of the fruit and select the month in the dropdown list

 

[jarjarbingie]

how to calculate YTD with 2 criterias (i.e. heading is the month from B1 to M1 and Specific Code in the column A2 TO A10)

Example
A2 – A10 has name of the fruits
B1 to M1 has Jan to Dec
Each fruit has a value from Jan – Dec entered in B2 – M10

I want to get the YTD total of fruit if I type in the name of the fruit and select the month in the dropdown list

=SUM(OFFSET($A$1,MATCH($P$2,$A$2:$A$5,0),1,1,MATCH($P$3,$B$1:$M$1,0)))

assuming P2 is the fruit and P3 is the month

 

[mart_mrexcel]

Thanks that works great