Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks Claus, it works great. You're awesome
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't figure out Simple Percent Label | Charts and Charting in Excel | |||
Simple Question..if there is such a thing in Excel | Excel Programming | |||
Simple IF thing? | Excel Programming | |||
Why does this simple thing not work? | Excel Programming | |||
Simple Thing | Excel Programming |