Formula needed for Lookup - Possible Array?

[Robnrolla]

		1	1	1	1	1	2	2	2	2	2
Store Takings		507659	4788131	1922938	1611230	1597516	4097383	1867506	1385749	1363487	1494906
Wholesale		11377	60284	22953	52458	39394	99191	20885	52102	147308	27181

<tbody>
</tbody>

I want to lookup a number in the first row and lookup one of the names in the first column and return the sum of all the amounts that are inline with the selected number from the first row.

I would be very grateful if anyone has any suggestions.

Thanks,

 

[rizwan_planning]

You can use Sum product Here is link
https://www.extendoffice.com/documents/excel/4097-excel-sum-based-on-column-and-row-criteria.html

 

[Robnrolla]

Thank you, that worked perfectly.

Kind regards,