Percentage flag

[soulmiester]

Hi all this is my first time here so please be gentle.
I have a basic sales board consisting of reps, days of the week, double sales and single sales, mandates and total. Each mandate can be a single or a double but what i need is a formula that will flag the mandates cell if the total doubles sales breaches 30% of the total mandates sold.
Example.
Steve on monday sells 8 lines, 3 doubles and 2 singles and does this monday to friday. This would give him 15 doubles and 10 singles, giving him 25 total mandates. The ratio from 15 doubles to 25 mandates, this represents 60% doubles sales.
What i need is a formula to insert into a new column that shows that percentage relation and for it to flag if it breaches 30%
I know this is long winded but its the only way i could explain what help i need.
Any and all help and advice would be appreciated.
Thank you.
Lee.

 

[etaf]

lets assume some cells for the TOTAL - I assume you have the totals somewhere ?
otherwise we need to know the layout of the sheet

you have total doubles - in cell H2 say
you have total singles - in Cell I2 say

then in a new column lets say Z2

=H2/(H2+I2) or 15/(15+10)
that would = 0.6
format the cells as percent

You can use conditional formatting on the column . Z
select Z2:Z1000 - or however many rows you have
then use a formula
Z2>0.3
fill colour RED - now the cells above 30% will be filled with red

if you dont have a total for Double and Singles for the week
need really to know what cells you are using for what
otherwise you would use a SUM() for the range of days you want for Doubles and SUM() for singles

 

[soulmiester]

Im sorry but i can not upload an image or the excel sheet to show you.

And i cant figure this out for the life of me and i dont know how best to explain further.

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[soulmiester]

ok i think this might explain, cells run from B is name, C to P is Singles and doubles, the mandates column has this formula, =SUM((D6+F6+H6+J6+L6+N6+P6)/2+(C6+E6+G6+I6+K6+M6+O6))
Total has this formula =SUM(C6:P6). What i need is a column inserting before mandates which shows the percentage of doubles sold. hope this helps.
thanks, lee[TABLE="width: 708"]
<colgroup><col><col span="14"><col><col></colgroup><tbody>[TR]
[TD]
week com [/TD]
[TD="colspan: 5"]19/11/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]




[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD="colspan: 2"]Mon[/TD]
[TD="colspan: 2"]Tue[/TD]
[TD="colspan: 2"]Wed[/TD]
[TD="colspan: 2"]Thur[/TD]
[TD="colspan: 2"]Fri[/TD]
[TD="colspan: 2"]Sat[/TD]
[TD="colspan: 2"]Sun[/TD]
[TD]Mandates[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Mark Rankin(d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Darren Mitchell (v)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]34[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]Craig Hamilton (v)[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]18[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]Dan Cosgrove (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]13[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]Jackie Scott (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]16[/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]32[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]Tai Hussain (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Vjay Hara (d)[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]19[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]Jeremy (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Jo Evers (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Beth (V)[/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]9[/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]40[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]Shaun (D)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Kev Kelly (D)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Luke (v)[/TD]
[TD="align: right"]14[/TD]
[TD] [/TD]
[TD="align: right"]13[/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD="align: right"]16[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]49[/TD]
[TD]49[/TD]
[/TR]
[TR]
[TD]Carl Stephens (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]18[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]Ryan Jones (v)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]13[/TD]
[TD] [/TD]
[TD="align: right"]17[/TD]
[TD] [/TD]
[TD="align: right"]14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]44[/TD]
[TD]44[/TD]
[/TR]
[TR]
[TD]Phil Bewley (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]13[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]Lee C (d) (V)[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Danny Doyle (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]14[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD="align: right"]37[/TD]
[TD] [/TD]
[TD="align: right"]48[/TD]
[TD] [/TD]
[TD="align: right"]66[/TD]
[TD] [/TD]
[TD="align: right"]96[/TD]
[TD] [/TD]
[TD="align: right"]62[/TD]
[TD] [/TD]
[TD="align: right"]17[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD]329[/TD]
[TD]332
[/TD]
[/TR]
</tbody>[/TABLE]

 

[soulmiester]

Ok i think this may help. column c is name, C to P are singles and doubles. the mandates cell has the following formula, =SUM((D6+F6+H6+J6+L6+N6+P6)/2+(C6+E6+G6+I6+K6+M6+O6)) and the totals column has this formula, =SUM(C6:P6)
What i need to figure out is to insert a column before mandates showing the percentage of doubles sold over the total mandates and to flag if it breaches 30%

thanks, lee

[TABLE="width: 708"]
<colgroup><col><col span="14"><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD="colspan: 2"]Mon[/TD]
[TD="colspan: 2"]Tue[/TD]
[TD="colspan: 2"]Wed[/TD]
[TD="colspan: 2"]Thur[/TD]
[TD="colspan: 2"]Fri[/TD]
[TD="colspan: 2"]Sat[/TD]
[TD="colspan: 2"]Sun[/TD]
[TD]Mandates[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD]S[/TD]
[TD]D[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Mark Rankin(d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Darren Mitchell (v)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]34[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]Craig Hamilton (v)[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]18[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]Dan Cosgrove (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]13[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]Jackie Scott (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]16[/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]32[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]Tai Hussain (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Vjay Hara (d)[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]19[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]Jeremy (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Jo Evers (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Beth (V)[/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD="align: right"]7[/TD]
[TD] [/TD]
[TD="align: right"]9[/TD]
[TD] [/TD]
[TD="align: right"]8[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]40[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]Shaun (D)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Kev Kelly (D)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Luke (v)[/TD]
[TD="align: right"]14[/TD]
[TD] [/TD]
[TD="align: right"]13[/TD]
[TD] [/TD]
[TD="align: right"]6[/TD]
[TD] [/TD]
[TD="align: right"]16[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]49[/TD]
[TD]49[/TD]
[/TR]
[TR]
[TD]Carl Stephens (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]18[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]Ryan Jones (v)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]13[/TD]
[TD] [/TD]
[TD="align: right"]17[/TD]
[TD] [/TD]
[TD="align: right"]14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]44[/TD]
[TD]44[/TD]
[/TR]
[TR]
[TD]Phil Bewley (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]13[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]Lee C (d) (V)[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Danny Doyle (d)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]14[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD="align: right"]37[/TD]
[TD] [/TD]
[TD="align: right"]48[/TD]
[TD] [/TD]
[TD="align: right"]66[/TD]
[TD] [/TD]
[TD="align: right"]96[/TD]
[TD] [/TD]
[TD="align: right"]62[/TD]
[TD] [/TD]
[TD="align: right"]17[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD]329[/TD]
[TD]332[/TD]
[/TR]
</tbody>[/TABLE]

 

[etaf]

you may want to delete the post or ask a moderator too - as you have names in are they real ?

 

[etaf]

why the /2
=SUM((D6+F6+H6+J6+L6+N6+P6)/2

you can use a SUMIF()

I have done it all here

https://www.dropbox.com/s/3idnznna25hu7gl/Book2_etaf.xlsx?dl=0

 

[soulmiester]

The reason for the 2 is so the double mandates calculate as double in the mandates column.

 

[soulmiester]

Ive just looked at it and yes thats kind of what im after only take name 3, the 6 is represented as 6 singles where as we would report that as 3. As in 3 doubles and 15 singles = 21. Thats the reason for the 2 in the original formula. Apart from that you have nailed it.