Help with Excel 2007 formula - Divide SUM of Cells

1. 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 devide the sum of cells E, G, I, K, M, O, Q, Sand S and U by Cell D and present the result in Column A in each of the rows.

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 ``Please Login or Register  to view this content.``
but didn't work. Like I said above, I am rusty with Excell.  Register To Reply

2. Re: Help with Excel 2007 formula

Welcome to the board.

Thanks.  Register To Reply

3. Re: Help with Excel 2007 formula - Divide SUM of Cells

There are two components of a cell address, vis. column(A, B,...) and row (1,2,...) --> A1, A2, AA113, etc
=(E1+G1+I1+K1+M1+O1+Q1+S1)/D1
or,
=SUM(E1,G1,I1,K1,M1,O1,Q1,S1)/D1  Register To Reply

4. Re: Help with Excel 2007 formula - Divide SUM of Cells

Or this...
=(E1+G1+I1+K1+M1+O1+Q1+S1)/D1
OR
=SUM(E1,G1,I1,K1,M1,O1,Q1,S1)/D1

OR, depending in what is in the intervening cells,,,
=SUM(E1:S1)/D1  Register To Reply

5. Re: Help with Excel 2007 formula - Divide SUM of Cells

Welcome to the forum. We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I am posting the links for you.)

https://www.excelguru.ca/forums/show...e-SUM-of-Cells

https://www.ozgrid.com/forum/forum/h...e-sum-of-cells  Register To Reply

6. Re: Help with Excel 2007 formula - Divide SUM of Cells Originally Posted by protonLeah There are two components of a cell address, vis. column(A, B,...) and row (1,2,...) --> A1, A2, AA113, etc
=(E1+G1+I1+K1+M1+O1+Q1+S1)/D1
or,
=SUM(E1,G1,I1,K1,M1,O1,Q1,S1)/D1
I used ``Please Login or Register  to view this content.``
in A2. Now I need to copy a range in column A so each row is referenced correctly as ``Please Login or Register  to view this content.``
All the way down to A238.

I just forgot how to do that.  Register To Reply

7. Re: Help with Excel 2007 formula - Divide SUM of Cells

The fill handle is the small square the bottom right of the selection marquee. Grab that and pull down.  Register To Reply

8. Re: Help with Excel 2007 formula - Divide SUM of Cells

I don't see a small square fill handle.
I remember doing it differently by highlighting the cell holding shift and the down arrow until it highlights all the way down where I want to stop.
I need to reference each row.  Register To Reply

9. Re: Help with Excel 2007 formula - Divide SUM of Cells

Look at the screenshot.  Register To Reply

10. Re: Help with Excel 2007 formula - Divide SUM of Cells

Thanks. I found it.

Now I need to format Column A so that numbers are rounded 2 places to the right of the decimal point.
Such as 16.6667 becomes 16.67

Also, color a Column with some color all the way down.  Register To Reply

11. Re: Help with Excel 2007 formula - Divide SUM of Cells

I have it formatted the way I like it.
Thanks for everyone's help.  Register To Reply

12. Re: Help with Excel 2007 formula - Divide SUM of Cells

Well I thought this was solved but as I took the time to review the results they were way off just by looking at them.

I used the method as suggested by grabbing the fill handle and drug it down.

My formula starts in A2 and is: ``Please Login or Register  to view this content.``
and I expected A3 to have: ``Please Login or Register  to view this content.``
and A4 to have: ``Please Login or Register  to view this content.``
and so on all the way down changing to the respected row.

I found every one was wrong.

SO, I am asking how to fix this?  Register To Reply

13. Re: Help with Excel 2007 formula - Divide SUM of Cells

In what way were the 'wrong'? What did you get instead of your expected results?  Register To Reply

14. Re: Help with Excel 2007 formula - Divide SUM of Cells

Are calculations set to Manual?  Register To Reply

15. Re: Help with Excel 2007 formula - Divide SUM of Cells  Register To Reply