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

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

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

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