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

Hi,

Am Wed, 19 Mar 2014 15:25:26 +0000 schrieb Naxzor:

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.

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


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional

Thanks Claus, it works great. You're awesome