Using =SUM...just can't figure this simple thing out...

[Naxzor]

Hey everyone,

I'm trying to get this formula to work. It seems very simple, but it'
just not working for me. Someone here can probably see what's wron
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 tha
total needs to be multiplied by (B29/100 and then add 1). Then whe
that's all done, add the cells J11:J13,J26 to the total.

Any ideas? Would be greatly appreciated.

Thank

 

[Claus Busch]

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.

 

[Naxzor]

Thanks Claus, it works great. You're awesom