I have a group of 1000 records of survey responses that include ratings to an array of areas For each rating I want to show the total count of the records in the sample that responded with that rating, however then in then have an average column that incorporates the records weight (each record with the "Latest Decision" = "Withdrawl" representing 13.0176 and records with the "Latest Decision" = "IE" counting representing 4.2760 when drawing conclusions about the entire population since not all individuals completed the survey. I have various demographic categories that I wish to include as criteria in the average columns for each rating. You can get an idea of what I am trying to do as I have calculated for the average with an =averageif but cannot quite figure out the correct use of =sumproduct and =sumif to write a formula for each cell and the necessary criteria for the average column.
Here is a small sample file.
Example.xlsx
Bookmarks