A bit stuck

[Clemo1]

Hi Guys,

I am trying to sum and average certain cells along rows but cannot work out the easiest way to do this.

Example:
Row A
I have different percentages in row A which i want to sum total and average.
To do this i need to sum only all the cells with the percentages in and average once counted.
Problem I have is that there are cells between which have no value (but will have in future months, hence the need for a formula) and cells which have values which I am using for another calculation.

Can anybody help?

 

[GR00007]

Summing percentages is something I stay away from preferring to sum the raw data and calculate the correct percentage.
Please give an example of what data you are using.

 

[Clemo1]

I am just using values of £ which employees have earnt during a month and then trying to calculate a % in relation to what they should actually earn.

 

[GR00007]

You haven't given much to go on. What is the criteria for calculating a percentage - do you have a standard rate for tasks being done that the employee's time on that task can be used?
Here's a complete guess:
[TABLE="class: grid, width: 256"]
<tbody>[TR]
[TD="width: 64"]EmpID[/TD]
[TD="width: 64"]Effecency[/TD]
[TD="width: 64"]Actual[/TD]
[TD="width: 64"]Deserve[/TD]
[/TR]
[TR]
[TD]Emp1[/TD]
[TD="align: right"]0.9[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£450.00[/TD]
[/TR]
[TR]
[TD]Emp2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£500.00[/TD]
[/TR]
[TR]
[TD]Emp3[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£550.00[/TD]
[/TR]
[TR]
[TD]Emp4[/TD]
[TD="align: right"]0.5[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[/TR]
[TR]
[TD]Emp5[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£750.00[/TD]
[/TR]
[TR]
[TD]Emp6[/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£400.00[/TD]
[/TR]
[TR]
[TD]Emp7[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£600.00[/TD]
[/TR]
[TR]
[TD]Emp8[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£350.00[/TD]
[/TR]
[TR]
[TD]Emp9[/TD]
[TD="align: right"]1.3[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[/TR]
[TR]
[TD]Emp10[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£300.00[/TD]
[/TR]
[TR]
[TD]Emp11[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£700.00[/TD]
[/TR]
[TR]
[TD]Emp12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]£500.00[/TD]
[TD="align: right"]£500.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[Clemo1]

Apologies. I will ty and explain a bit better...………….

So in row 6 I have percentages in B6,E6,K6,S6,U6 and V6.
In between these I have cells in row 6 which have either no value as yet but may do next month when I enter next months totals or have another value which I do not want to sum. These are in C6,D6,F6 etc.
I am trying to find a formula which will sum specific cells and average those cells which have been counted/summed to give an average percentage.

i.e.
25%+15%+-3%+75%=-92% = 20%/5 = 4%

 

[GR00007]

Going back to the original statement - calculating using percentages as data can skew the results - it's much better to recalculate on the raw data. Do you have an actual example of all the columns of row six, and what is being used to calculate the percentages?

25+15+-3+75 = 112 and how does that get to 20?