Percent formula

[IronMan1982]

Hi, I am looking for some help to workout some calculations below, there are thousands of lines of data all in varying columns so i was wondering if there was an easier way to work out per centages without having to go through line by line or by filtering blanks and doing it by column if that makes sense.



[TABLE="width: 768"]
<TBODY>[TR]
[TD] [/TD]
[TD]A</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[TD]C</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD]E</SPAN>[/TD]
[TD]F</SPAN>[/TD]
[TD]G</SPAN>[/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD]Person 1</SPAN>[/TD]
[TD]Person 2</SPAN>[/TD]
[TD]Person 3</SPAN>[/TD]
[TD]Person 4</SPAN>[/TD]
[TD]Person 5</SPAN>[/TD]
[TD]Grand Total 2015</SPAN>[/TD]
[TD]% of total</SPAN>[/TD]
[/TR]
[TR]
[TD]2</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5</SPAN>[/TD]
[TD] [/TD]
[TD]1</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1</SPAN>[/TD]
[TD] [/TD]
[TD]6</SPAN>[/TD]
[TD] [/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=5><COL><COL></COLGROUP>[/TABLE]

 

[bewsh1987]

sorry am a little lost here.

i take it there should be a 1 in row 6

can you paste what the percentages should look like?

 

[Special-K99]

Try

in G2
=SUM(A2:E2)/SUM(F$2:F$7)*100
and copy down

 

[IronMan1982]

hi bewsh1987,

yes there should have been that was a typo on my part,

i basically need the numbers in columns A - E to be divided by the total on column F on the same row to give the % in G. hopefully that makes it clearer.

sorry am a little lost here.

i take it there should be a 1 in row 6

can you paste what the percentages should look like?

 

[bewsh1987]

Hi ironman1982

This should work


=sum(A2:E2)/F2

 

[IronMan1982]

thank you!

 

[IronMan1982]

perfect cheers bewsh1987, spot and nice and simple too (embarrassed i never thought of it now!)