Return a range of values by comparing to a list

[Neutralizer]

Hi,

Please see the attached picture to illustrate my question.

In each of the yellow boxes, I need to use a function that will allow me to calculate the mode of all the 'A' numeric values associated with an 'A' value in the large table....and also for B & C.

Does anyone know a way to do this? I assume it will need to be an array formula but I'm not to sure about how to use array formulas or how to make it match all the corresponding values in the larger table, rather than just one.

Cheers

[antoka05]

You could try to use this formula to put in 'B1':

=SUMIF(D$1:D$16,$A1,E$1:E$16)

Regards,
Antonio