No.....Here is my example....

John 50%
Eddie 48%
Eddie 55%
Eddie 66%
John 48%
John 40%

Now I know how to find the averages if I wanted to do it manually, but these
figures are just part of a data sheet. I am looking for the average precent
per technician based of of precents, not totals.

"Pete_UK" wrote:

Let's say the two technicians do two jobs - for the first (which is
worth, say, $500) the split is 90%:10%, but on the second job (worth
$2000) the split is 40%:60%. The strict average of the percentage
split is 65%:35%, but this is meaningless. You need to take the value
of each job split between the two, i.e. 450:50 and 800:1200 and
compare these - 1250:1250, or 50%:50%.

Hope this helps.

Pete

On Jun 30, 5:38 pm, MPAVLAS wrote:
The percentage is Gross Profit on a job. Yes, job size does matter but there
would be too many variables to sort through to make the report completely
accurate. I am just lloking to find the avergae gross precentage of each
technician.

If I sort the techs myself I can easily find there average, but I do not
want seperate pages for each tech. I owuld like to just be able to use excel
to sort through the list and do it for me. I know it is possible, I have seen
excel do way more.



"Pete_UK" wrote:
You really need to know the size of each job, as you can't just add
the percentages together and take an average. Someone with a large
percentage of a small job would be skewed compared to someone else
having a smaller percentage of a larger job.

Hope this helps.

Pete

On Jun 30, 4:47 pm, MPAVLAS wrote:
I have two columns.

one contains two variables (John or Eddie)

the other contains a precentage per job relative to the painter (john or
Eddie).

What is the best way to get an average percentage for each of the painters.- Hide quoted text -

- Show quoted text -