HELP With SpreadSheet: Advanced Calculation

[devexity]

Ok so here is the issue I'm having. Currently the TOTAL PROMOTION POINTS column (R) is a Sum of the specific cells in each row (E, H and Q) as shown below. I also want to add an additional BONUS of 25-points for those that make the Hall of Fame's TOP KILLS & TOP BUILT at the bottom (B29 & B30).

The formula I use for the Hall of Fame is: =INDEX(A2:A24,MATCH(MAX(J2:J24),J2:J24,0))

So now Im stuck on how to not only assign 25 points to the Hall of Fame entries, but then assign it to the correct corresponding TOTAL PROMOTION POINTS formula.

So in this example, JUICED currently has 31 Total Promotion Points (R9), but he made TOP KILLS (Hall of Fame A29). So I need the spreadsheet to add 25 points to 31 to equal 56 in R9.

If anyone has the slightest idea of how to make this possible, please help!

I assume that somewhere the value of those entries in B29 & B30 must be specified to equal 25-- and perhaps it's in the equation for TOTAL PROMOTION POINTS to Check if the user was the MAX between the range of either M2:M24 (Top Kills) or I2:24 (Top Build), and IF true, add +25 to the total. Maybe it's not possible, or maybe Im over thinking it.

 

[Noodleski]

could you expand your formula in column R to

sum(E7+H7+Q7)+if(ifna(match(A7,$B29:$B30,0),0)>0,25,0)

 

[devexity]

could you expand your formula in column R to

sum(E7+H7+Q7)+if(ifna(match(A7,$B29:$B30,0),0)>0,25,0)

I get the following Error:

 

[Noodleski]

Hmm, an older excel version probably.
What happens when you replace IFNA by IFERROR in that same formula?

 

[devexity]

Hmm, an older excel version probably.
What happens when you replace IFNA by IFERROR in that same formula?

That solved it! Thanks! Ya, I guess I should have added that Im using Google-Sheets (not Microsoft Excel).