new spreadsheet

[Jonker19]

I would like to creat a second spreadsheet on the same workbook as th
attached pic of the sheet. I would like to have the second sheet hav
just 2 columns..1 Employee and second Effiecny Percentage. I would lik
the second sheet to find all the rows with the inspectors name, then ad
together all percentage to give me a avgerage daily inspectio
efficency.

I need help with the formula. These two colums will be in the A and
columns on the second spreadsheet.

Thanks in advance for the help

+-------------------------------------------------------------------
|Filename: excel screetshot.bmp
|Download: http://www.excelforum.com/attachment.php?postid=2666
+-------------------------------------------------------------------

 

[Frank Kabel]

Hi
use a pivot table for this:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm