Getting the formula right

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

  1. highstream

    highstream

    Joined:
    Oct 6, 2015
    Messages:
    13
    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:
    25
    Likes Received:
    9
    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:
    13
    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:
    25
    Likes Received:
    9
    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:
    13
    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:
    25
    Likes Received:
    9
    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

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 (here). After that, you can post your question and our members will help you out.