V-look up of horizontal look up problem?

[Mirisage]

Hi Forum,
In the attached, I have 3 source tables, called Table 1, Table 2 and Table 3.

Problem:
Using these 3 tables, I have to calculate the summary table indicated in multi-colours to answer below 4 questions:

1). When intervention = 1, then what is the total # of people across three source tables = 255
2). When intervention = 2, then what is the total # of people across three source tables = zero
3). When intervention = 3, then what is the total # of people across three source tables = 59
4). When intervention = 4 then what is the total # of people across three source tables = 52

To calculate the summary table, we need only two rows of three source tables. They are: "# of people" and "Intervention".
I have calculated the answers, using sum function.

Question:
I have shown you only 3 source tables but my original data set has some hundreds of tables.
So, using sum function and highlighting and clicking "interventions" one at a time is clumsy.

Could anyone help me to create the above 4 answers using v-lookup or horizontal lokk up or something like that.

Thanks

Mirisage

[FDibbins]

Try this, copied down...
=SUMIF($B$9:$O$9,H15,$B$3:$O$3)

[Mirisage]

Hi FDibbins,

Thank you very much.

Your suggestion worked very well.
Thanks again
Mirisage

[FDibbins]

Happy to help and thanks for the feedback