Sum Data based on city and level

[webmax]

Hi
I have data with 3 columns in the excel sheet attached.
1st Column is Region, 2nd column is Level and 3rd column is Marks
I need sum the Marks based on the Region and Level
Attaching the excel sheet with Input data and output Data
Kindly do the needful

Thanks

 

[AlanSidman]

Create a Pivot Table.
1. Region to Rows
2. Level to Columns
3. Marks to Values

 

[bosco_yip]

Try,

In I5, formula copied across right and down :

=SUMIFS($C:$C,$A:$A,$H5,$B:$B,I$4)