Percentages

[triad]

I am trying to get some percentages from a sheet that I have imported with
about 300 stock prices. I want to get what percent D 1-300 is of C 1-300 and
have the answer go to H. I checked the help file and can't seem to find
this. Thanks

 

[DDM]

Triad, in Cell H1: =D1/C1 and press enter. Format the cell as %. Copy the
formula down Column H.

Or if you mean whole columns, then =SUM(D1300)/Sum(C1:C300).

 

[triad]

Thanks DDM!

Triad, in Cell H1: =D1/C1 and press enter. Format the cell as %. Copy the
formula down Column H.

Or if you mean whole columns, then =SUM(D1300)/Sum(C1:C300).