Forum Groups
  All forums
    Help & Feedback
      Questions
      Work in progress
      Finished Art
      Non-Max related
    Community
      Offtopic
      News
    Hardware
    Photography



Maxunderground news unavailable

Any Excel Wizards here?
show user profile  zeefusion
I am trying to do a simple calculation but not sure exactly how to write it in Excel.

I want to add up cells A1 to A5 but then subtract cell A6 and then add cells A7 - A10. Any ideas how I would write that in Excel? Cell A6 can be subtracted at the end, it doesn't matter. Its just that that particular value is in amongst others that needed to be added.

Thanks!
read 390 times
12/29/2011 11:11:01 AM (last edit: 12/29/2011 11:11:01 AM)
show user profile  c0
http://www.ehow.com/how_9699_create-excel-formula.html

1. Double click on the cell that will be used to display the result of the calculation.
2. Press the equal symbol ('=') to enter formula editing mode.
3. Click on cell A1
4. Type a plus ('+') symbol
5. Click on cell A2
etc.
99. Press Enter when done.

My 2 cents...cell A6 should be added, not subtracted + enter the value for A6 as a negative value...and use the 'sum' function (click on the fx button) on the whole A column to allow for a growing dataset.
read 383 times
12/29/2011 11:42:48 AM (last edit: 12/29/2011 11:50:06 AM)
show user profile  S. Silard
Click the cell where you want see the result , and write in :
=(A1+A5)-A6+A7+A10

Congrats, you found my signature.

read 380 times
12/29/2011 11:46:07 AM (last edit: 12/29/2011 11:46:07 AM)
show user profile  zeefusion
Thanks :)
read 374 times
12/29/2011 11:46:57 AM (last edit: 12/29/2011 11:46:57 AM)
show user profile  npcph
=((SUM(A1:A5))-A6)+SUM(A7:A10)

Silards will not add the sum of a1 to a5 and a7 to a10. it will only add a1 to a5 and a7 to a10.

read 349 times
12/29/2011 5:07:05 PM (last edit: 12/29/2011 5:07:49 PM)
show user profile  Sir_Manfred
npcph: Too late, man! Zeefusion already filed his faulty tax-return!



Visit my Portfolio
http://www.Freds3D.com

read 336 times
12/29/2011 7:24:58 PM (last edit: 12/29/2011 7:24:58 PM)
#Maxforums IRC
Open chat window


Support Maxforums.org