Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
average help
Hi I am lookng for some help with an average question,
I have a spreadsheet to work out lines and parts picked per minute and then the average. The only problem i have is person a does less in more minutes but his average works out more than person b an example Lines Parts Minutes Ave Lines per min Ave Parts per min 47 63 435 15 12 67 67 315 8 8 Now the sum for ave per min is C2/A2/60*100 Format cell minus 2 decimal point Just by looking at it person a has done less inmore time but averages twice as much, what am i doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling average | Excel Worksheet Functions | |||
Modified Average Function | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions | |||
average function in Excel 2002 | New Users to Excel |