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

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

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

    I would like the results presented in % rounded to 2 digits to the right of the decimal 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 separately.

    I tried


    but didn't work. Like I said above, I am rusty with Excell.


    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.

    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 who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!