Formula to Sum a Matrix Table

[odartey]

Hello all,
Trust you all doing well.
Can i please get help with the table i have uploaded
In the Table, i have Row and Column labels, of which i have figures in them.
i want summarize the table by the unique labels.
Thanks for the anticipated help

 

[eibi]

Formula:

=SUMPRODUCT($I$9:$P$14*(--($I$8:$P$8=I$19))*(--($H$9:$H$14=$H20)))

See attached.

 

[Nebu]

Hi:

I guess , you can get rid of the negation part and few brackets for the above formula.

=SUMPRODUCT($I$9:$P$14*($I$8:$P$8=I$19)*($H$9:$H$14=$H20))

Thanks

 

[Khalid NGO]

Hi odartey, and all,

(with thanks to David) Another option could be:

=SUM(MMULT((($I$8:$P$8=I$19)*($H$9:$H$14=$H20)*$I$9:$P$14),1^$A$1:$A$8))

Regards,

 

[odartey]

Formula:

=SUMPRODUCT($I$9:$P$14*(--($I$8:$P$8=I$19))*(--($H$9:$H$14=$H20)))

See attached.

Thanks so much eibi
very grateful

 

[odartey]

Hi:

I guess , you can get rid of the negation part and few brackets for the above formula.

=SUMPRODUCT($I$9:$P$14*($I$8:$P$8=I$19)*($H$9:$H$14=$H20))

Thanks

Thanks Ninja for the revised formula
Very much appreciated

 

[odartey]

Hi odartey, and all,

(with thanks to David) Another option could be:

=SUM(MMULT((($I$8:$P$8=I$19)*($H$9:$H$14=$H20)*$I$9:$P$14),1^$A$1:$A$8))

Regards,

Thanks Khalid, very grateful