How to sum columns based on two column headers as criteria

Hi,

I have here a table in which I need to get the total amount of "No" and "Sales" of the parameter I put on cell A23.

I'm my current formula in cell B23 and C23, I'm only getting the value of the first row. I couldn't quite figure out the formula that would sum up the whole column.

Also, I made a data list on cell A23, in which if I change it, the formula in cell B23 and C23 would automatically populate.

Hope someone could help me out! Thank you!

Perhaps……….

In B23, copied right to C23

=OFFSET($A15,0,MATCH($A23,$B$1:$P$1,0)+MATCH(B$22,$B$2:$D$2,0)-1)

or,

=SUM(INDEX($B$3:$P$14,,MATCH($A23,$B$1:$P$1,0)+MATCH(B$22,$B$2:$D$2,0)-1))

Regards
Bosco

Thank you both for the help!

I think the last formula from Bosco works perfectly! it captures all the figures that I need!

Thank you!