View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott at Medt.[_2_] Scott at Medt.[_2_] is offline
external usenet poster
 
Posts: 5
Default 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