Array formula or similar needed - Again!

I'm working with wookbooks used company wide and I cannot add any helper columns which would solve the problem. I need to add data which meets certain conditions plese see attached workbook for a sample.

Any ideas gratefully received...

Is that exactly your setup? I mean you have 1 to 25 in A4:A28 and 1 to 25 in A37:B61?

if so a simple Sumif() will do it.

e.g. in B32: =SUMIF(B$37:B$61,A32,B$4:B$28) copied down. You can then copy to other columns

In case they were not numbered the same (ie. 1 to 25 in both ranges or mixed around).. then this formula in B32 would yield the same result:

=SUMPRODUCT((B$37:B$61=A32)*($A$37:$A$61=$A$4:$A$28),B$4:B$28)

No problem.

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save