Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Multiple Array Criteria - Determine Average Result
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Multiple Array Criteria - Determine Average Result
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Multiple Array Criteria - Determine Average Result
Hi Roger,
Everything has worked until the last step. First off, thank you for your great suggestion. I must not be double clicking on the right spot because when I do no drop down appears rather a new worksheet appears with data in it. Any thoughts? "Roger Govier" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Multiple Array Criteria - Determine Average Result
Hi Scott
Try Right click on PTPT WizardLayoutdouble click on the Days field in the Data areaselect average from dropdownOKFinish -- Regards Roger Govier "Scott at Medt." wrote in message ... Hi Roger, Everything has worked until the last step. First off, thank you for your great suggestion. I must not be double clicking on the right spot because when I do no drop down appears rather a new worksheet appears with data in it. Any thoughts? "Roger Govier" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple criteria options determine which name to show as result. | Excel Worksheet Functions | |||
how can I have a formula result based on multiple criteria/columns | New Users to Excel | |||
Multiple Criteria in SumProduct, N/A Result | Excel Worksheet Functions | |||
How do I Provide a specific result given multiple criteria? | Excel Worksheet Functions | |||
Return result from multiple criteria | Excel Worksheet Functions |