Formula needed for Lookup - Possible Array?

[Robnrolla]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Store Takings[/TD]
[TD][/TD]
[TD]507659[/TD]
[TD]4788131[/TD]
[TD]1922938[/TD]
[TD]1611230[/TD]
[TD]1597516[/TD]
[TD]4097383[/TD]
[TD]1867506[/TD]
[TD]1385749[/TD]
[TD]1363487[/TD]
[TD]1494906[/TD]
[/TR]
[TR]
[TD]Wholesale[/TD]
[TD][/TD]
[TD]11377[/TD]
[TD]60284[/TD]
[TD]22953[/TD]
[TD]52458[/TD]
[TD]39394[/TD]
[TD]99191[/TD]
[TD]20885[/TD]
[TD]52102[/TD]
[TD]147308[/TD]
[TD]27181[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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,