Hi Scott

Use a Pivot table.
Place your cursor in the data table, DataPivot TablesFinish
On the PT skeleton that appears on the new tab,
Drag State to the Row area
Drag City to the Row area
Drag Days to the Data area
Double click on the Sum of Days field that appears, and select Average from
the dropdown list
--
Regards
Roger Govier



"Scott at Medt." wrote in message
...
I have a data table with three colums;
State / City / Days to Complete Training

I want to provide a report (table) that shows the average days to complete
for each city.

I assume it will be a function that would include some use of sumproduct
but
very unsure how to include the "average" result portion.

Thanks!!!
Scott