+ Reply to Thread
Results 1 to 4 of 4

SIMPLE multiple step math formula question, DONT LAUGH AT ME just need some help :D

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    42

    Exclamation SIMPLE multiple step math formula question, DONT LAUGH AT ME just need some help :D

    I have a multiple-step simple formula that I need to implement, I have attached a sample below, essentially I want to add A1+B1 then divde it by C1, I then want that result to sum with all the other results below it (ex. A2+B2/C2 etc.). The part I dont know is how to do that for mutiple rows without throwing in an additional column. Basically I need to do whats in the gray boxes in 1 formula without needing those two gray columns to pull from, my explanation is confusing but the problem is simple I know it. PLease help! thanks everyone :-]Example Multi Step Math.xlsx

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: SIMPLE multiple step math formula question, DONT LAUGH AT ME just need some help :D

    You can use "array formulas" for this, i.e.

    =SUM(IF(A2:A7<>0,(B2:B7+C2:C7)/A2:A7))

    and

    =SUM(IF(A2:A7<>0,E2:E7/A2:A7))

    These formulas need to be entered with a specific key combination known as "CTRL+SHIFT+ENTER" - click on cell with formula - press F2 key to select formula then hold down CTRl and SHIFT keys while pressing ENTER. If done correctly you should get the correct results and curly braces like { and } should appear around the formula
    Audere est facere

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: SIMPLE multiple step math formula question, DONT LAUGH AT ME just need some help :D

    BEAUTIFUL! I knew it was simple.

    So basically its summing and dividing, now heres my question, only if its not zero? is that what the <> do? everything else I understand, but the <>0 i don't

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: SIMPLE multiple step math formula question, DONT LAUGH AT ME just need some help :D

    Yes, that's right, only if it's not zero, because if you divide by zero you'll get #DIV/0! errors and SUM function won't ignore those so if you use just

    =SUM((B2:B7+C2:C7)/A2:A7)

    that will return #DIV/0! error in your example because the blanks in A2:A7 are treated as zeroes - that version will work if all A2:A7 values are all non-blank and non-zero

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1