calculating inflated component costs

[Seattlites]

Hello,

I'm trying to identify the most efficient way to calculate individual component inflated costs (see columns AX and BA of the attached file). Inflated component costs are calculated by:

1) multiplying the uninflated costs in individual years (see UninflatedComponentCosts array in blue) by the compound inflation figure for that year located in row 85 at the very bottom
2) summarizing the individual annual inflated component costs across the array

Your help is most appreciated!


Regards,
Seattlite

[Estevaoba]

Try in BA6 copied down:
=SUMPRODUCT($H6:$AU6,(1+$H$85:$AU$85))

Good luck!

[Seattlites]

Thank you Estevaoba! I mistakenly did not subscribe and then missed your reply until just now.

I created a second worksheet that multiples each value on the first by the appropriate inflated value, but I will also try your solution now as well. It works perfectly. SUMPRODUCT to the rescue!

[Estevaoba]

You're welcome. Glad to help.
Thank you for the rep points and for marking the thread SOLVED.