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


N

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
 
Ad

Advertisements

C

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top