Sum Hlook up many columns

[KIM Chanthan]

Hi,

I am facing a problem to sum Hlook up with many columns.
Anyone can help?

Please view attached file for more detail question.

Thanks.
C

 

[Hui]

B9: =SUMPRODUCT(($B$2:$H$5)*($A$2:$A$5=$A9)*($B$1:$H$1=B$8))
Copy across and down

To understand this please read: http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/

 

[KIM Chanthan]

B9: =SUMPRODUCT(($B$2:$H$5)*($A$2:$A$5=$A9)*($B$1:$H$1=B$8))
Copy across and down

To understand this please read: http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/

Thanks very much! It is really helpful and easy to understand.