Percentage of total sales

[dunlopoil]

Hi,
Apologies for the basic query. I have a sheet of sales figures, sorted in descending order. Column G contains the order values. In column H, I want to set up a formula which enters a running total percentage of the total sales amount. Example as follows:

Total sales (cell G42): £100
Order value in G2: £20. Formula result in cell H2: 20%
Order value in G3: £20. Formula result in cell H3: 40%

Many thanks,
Doug.

 

[dafan]

H2:
=SUM(G$2:G2)/G$42

Drag down.

 

[dunlopoil]

Great- thanks Dafan.