Results 1 to 7 of 7

Thread: Help with Excel 2007 formula - Divide SUM of Cells

  1. #1
    Neophyte N7AS's Avatar
    Join Date
    Jun 2019
    Posts
    3
    Articles
    0
    Excel Version
    2007

    Help with Excel 2007 formula - Divide SUM of Cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am very rusty with Excel so here goes...
    I am using Excel 2007


    I need to be able to devide the sum of cells E, G, I, K, M, O, Q, and S by Cell D and present the resukt in Cell A.


    I would like the results presented in % rounded to 2 digits to the right of the decemil point. Such as 16.666666 would display as 16.67.


    I will have many rows (256 of them) and want the formula to work the same in all rows starting with A2 and giving the results for that row seperately.


    I tried
    Code:
    =(SUM=E+G+I+K+M+O+Q+S)/D
    but didn't work. Like I said above, I am rusty with Excell.
    Grant N7AS

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,245
    Articles
    0
    Excel Version
    Office 365 Subscription
    CROSS POST


    This question has been posted in at least one other forum.

    Do not post any further responses in this thread until a link has been provided to these cross posts.

    Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184

    This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.
    Please provide the link(s). If you are unable to do so, tell us where else you have posted this query.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    885
    Articles
    0
    Excel Version
    Excel 2013
    Perhaps
    Code:
    =ROUND(SUM(E1;G1;I1;K1;M1;O1;Q1;S1)/D1;2)
    or
    Code:
    =ROUND((E1+G1+I1+K1+M1+O1+Q1+S1)/D1;2)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  4. #4
    Neophyte N7AS's Avatar
    Join Date
    Jun 2019
    Posts
    3
    Articles
    0
    Excel Version
    2007

    [SOLVED] Help with Excel 2007 formula - Divide SUM of Cells

    [SOLVED]<br><br>I have gotten it all straightened out.<br>
    Thanks
    Last edited by N7AS; 2019-06-10 at 06:00 PM.
    Grant N7AS

  5. #5
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    178
    Articles
    0
    Excel Version
    2019
    For the benefit of those who have been watching this thread, would you please supply your solution so that others may benefit.

  6. #6
    Neophyte N7AS's Avatar
    Join Date
    Jun 2019
    Posts
    3
    Articles
    0
    Excel Version
    2007
    I solved my problem by using
    Code:
    =SUM(E2,G2,I2,K2,M2,O2,Q2,S2,U2)/D2*100

    I copied it all the way down the spreadsheet. It works ok.


    I use this to calculate the duty cycle of IALA Flash Codes used in Marine aids to navigation.
    Grant N7AS

  7. #7
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Thank you Ken for this secure forum.

Posting Permissions

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