Hi All you Excel Guru's,
I am drawing a brain fart.
The formula below is pretty self explanatory. Sum if the column identified by the match.
=SUMIFS(INDEX(Statistics!$A:$AO,0,MATCH(B$6,Statistics!$A$3:$AO$3,0)),Statistics!$A:$A,$A42)
However I want the the Sum range to be more than one column.
=SUMIFS(Sum(Statistics!$A:INDEX(Statistics!$A:$AO,0,MATCH(B$6,Statistics!$A$3:$AO$3,0)),Statistics!$A:$A,$A42)
But that doesn't seem to work. Any ideas or suggestions?
I am drawing a brain fart.
The formula below is pretty self explanatory. Sum if the column identified by the match.
=SUMIFS(INDEX(Statistics!$A:$AO,0,MATCH(B$6,Statistics!$A$3:$AO$3,0)),Statistics!$A:$A,$A42)
However I want the the Sum range to be more than one column.
=SUMIFS(Sum(Statistics!$A:INDEX(Statistics!$A:$AO,0,MATCH(B$6,Statistics!$A$3:$AO$3,0)),Statistics!$A:$A,$A42)
But that doesn't seem to work. Any ideas or suggestions?