Summarize the data

[Amol lad]

In the attached file you will see the data sheet.

In Cell no j i3 want to Tabulate the sales in to the table by using the formula. Which formula i should use to make the summary without manipulating the data. Assuming the data is an Pivot table. can you help me out chandoo??

 

[bosco_yip]

Try,

In K3, formula copy across and down :

=INDEX($C$3:$C$26,MATCH($J3,$A$3:$A$26,0)+MATCH(K$2,$B$3:$B$5,0)-1)

Regards

 

[Amol lad]

Thanks bosco_yip that helps me a lot.