Getting the formula right

Discussion in 'Excel' started by highstream, Nov 9, 2016.

  1. highstream

    highstream

    Joined:
    Oct 6, 2015
    Messages:
    7
    Likes Received:
    0
    I'm trying to set up a cell that is the result of the following: Sum F77:F83 divided by sum D77:D83. Thus far I've yet to find a way without iterating each cell, but I know there must be. Ideas? Thanks,
     
    highstream, Nov 9, 2016
    #1
    1. Advertisements

  2. highstream

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    24
    Likes Received:
    8
    If I'm understanding you correctly, you can use:

    =sum(f77:f83)/sum(d77:d83)
     
    Amy @ German Pearls, Nov 10, 2016
    #2
    1. Advertisements

  3. highstream

    highstream

    Joined:
    Oct 6, 2015
    Messages:
    7
    Likes Received:
    0
    Hmm...For some reason that didn't work right for me this morning, at least with the sum sign. Now, it does with the text "sum," which I thought I tried too. Well, in any case it's now returning the (yellow) caution that adjacent cells are omitted. That's to be checked "ignore," right? Thanks,
     
    highstream, Nov 10, 2016
    #3
  4. highstream

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    24
    Likes Received:
    8
    As long as those are the correct cells you're referencing just ignore that error.
     
    Amy @ German Pearls, Nov 10, 2016
    #4
  5. highstream

    highstream

    Joined:
    Oct 6, 2015
    Messages:
    7
    Likes Received:
    0
    Strange it gives that error. Just realized why I was having problems this morning: \ vs. / Thanks for you help.
     
    highstream, Nov 10, 2016
    #5
  6. highstream

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    24
    Likes Received:
    8
    It tries to predict what formulas should be to help but it can't always understand what we're trying to do. Glad it's working for you. :)
     
    Amy @ German Pearls, Nov 10, 2016
    #6
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Nago
    Replies:
    0
    Views:
    517
  2. CarolB
    Replies:
    2
    Views:
    923
    XLPadawan
    Jun 15, 2016
  3. baldi
    Replies:
    1
    Views:
    768
    Sohail
    Dec 25, 2014
  4. marste7

    Copy and Paste Formula

    marste7, Aug 27, 2013, in forum: Excel
    Replies:
    1
    Views:
    687
    XLPadawan
    Jun 16, 2016
  5. asyluma
    Replies:
    0
    Views:
    453
    asyluma
    Oct 9, 2013
  6. teza2k06

    Conditional Formatting Formula

    teza2k06, Aug 23, 2014, in forum: Excel
    Replies:
    2
    Views:
    556
    XLPadawan
    Jun 16, 2016
  7. Janet Hudgins

    Set up formula for floor layout

    Janet Hudgins, Sep 23, 2014, in forum: Excel
    Replies:
    3
    Views:
    365
    XLPadawan
    Jun 16, 2016
  8. highstream

    Getting a page break to take

    highstream, Oct 6, 2015, in forum: Excel
    Replies:
    0
    Views:
    235
    highstream
    Oct 6, 2015
Loading...