Hey everyone,

I'm trying to get this formula to work. It seems very simple, but it's just not working for me. Someone here can probably see what's wrong right away...

=SUM(((J6:J8,J10,J15:J25)*((B29/100)+1))+J11:J13,J26)

I'm trying to add the cells (J6:J8,J10,J15:J25) together, and then that total needs to be multiplied by (B29/100 and then add 1). Then when that's all done, add the cells J11:J13,J26 to the total.

Any ideas? Would be greatly appreciated.

Thanks