Formula Sumifs with Index Match not working

Hi

I have a formula where I am using SUMIFS and INDEX MATCH however it is returning #VALUE, I have tried many ways to fix this formula but it does not work.
Please can someone help!

thanks in advance.

I have attached the spreadsheet.

Where (Cell) is the formula?

Hi John

I28 cell. The ones in Yellow

Two formulas in "Sheet2" giving #REF error need column defined as part of the INDEX ?????

Hi John

That is correct ! I cant work it out!!

This is the problem ..

=IF(((1+$C$28)^(G$25-$B28))=1,(1/((SUMIFS(INDEX($G$34:$P$46,0,MATCH($C$28,$G$33:$P$33,0)),$F$34:$F$46,">="&0,$F$34:$F$46,"<="&12-G25))))*$R$28,(F28*(1+$C$28)))


You had 33: should be 34.

OMG thank you so much!!!

Much appreciated!

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.