Formulas to Count and Sum Transposed Headings v2

[hammer2]

Hi Folks
Missed these scenarios in my earlier quest.
I have had to Transpose headings in another sheet which means I cannot just pull formulas across.

Sample attached with Sheets and Cells etc to exactly match my master Workbook.

Cheers
hammer

[Rino Rioux]

HI,

Here the formulas for M9:
=COUNTIFS(INDIRECT("SelsResults!"&SUBSTITUTE(ADDRESS(1,MATCH(K9,SelsResults!$1:$1,0)),"$1","")&":"&SUBSTITUTE(ADDRESS(1,MATCH(K9,SelsResults!$1:$1,0)),"$1","")),1,SelsResults!$A:$A,1)

And the formulas for P9:
=SUMIFS(SelsResults!$B:$B,INDIRECT("SelsResults!"&SUBSTITUTE(ADDRESS(1,MATCH(K9,SelsResults!$1:$1,0)),"$1","")&":"&SUBSTITUTE(ADDRESS(1,MATCH(K9,SelsResults!$1:$1,0)),"$1","")),1)

Regards,
Rino

[hammer2]

This is weird, I have input the exact information from my actual Workbook into the sample book and your formulas work fine.
But when I input the formulas into my actual Workbook I get different (incorrect) results- not sure why but still looking-

[FlameRetired]

Hello, hammer2 !

This is a slightly different approach.

Please Login or Register  to view this content.

in M9

and

Please Login or Register  to view this content.

in P9.

[hammer2]

Flame, manually checked and a Gold Star yet again Sir!

[FlameRetired]

Thank you, hammer for the feedback and kind words.