Averaging scores using V Look up

[DynamiteRave]

Hi everyone. I hit a brick wall and not sure what to do.

I'm using a Vlook up to track weekly trends of issue drivers, with a count of issues and an average of customer scores. So right now, my totals work just fine. It's the Score I can't seem to do. I attached the summary of what I'm doing and I'll attach an example of my data. For the counts, which works perfectly, I have this: =COUNTIFS(Data!F:F, "Delivery / Tracking",Data!A:A, Summary!C3) as an example. Week is Summary!C3 So when I change the week number, the data will change along with it. Pretty easy to do.

I just can't seem to figure out how to get the scores to average, by week, and by Issue. Any suggestions?

<colgroup><col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:5266;width:108pt" width="144"> <col style="mso-width-source:userset;mso-width-alt:5193;width:107pt" width="142"> </colgroup><tbody>
[TD="class: xl65, width: 159"]Week:
[/TD]
[TD="class: xl66, width: 88"]43
[/TD]
[TD="class: xl67, width: 144"] [/TD]
[TD="width: 142"][/TD]

[TD="class: xl68"]Dates:[/TD]
[TD="class: xl71"]11/19/2017[/TD]
[TD="class: xl72"]11/25/2017[/TD]

[TD="class: xl63"]Issue
[/TD]
[TD="class: xl69"]Score[/TD]
[TD="class: xl69"]Total[/TD]
[TD="class: xl69"]% of Feedback[/TD]

[TD="class: xl63"]Delivery / Tracking[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl70, align: right"]13%[/TD]

[TD="class: xl63"]Inventory / DC Issue[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl70, align: right"]13%[/TD]

[TD="class: xl63"]Service / Agent Engage[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl70, align: right"]13%[/TD]

[TD="class: xl63"]Return / Exchange[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl70, align: right"]13%[/TD]

[TD="class: xl63"]Loyalty / Rewards[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl70, align: right"]13%[/TD]

[TD="class: xl63"]Discount / Promos[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl70, align: right"]13%[/TD]

[TD="class: xl63"]Change / Cancel[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl70, align: right"]13%[/TD]

[TD="class: xl63"]Order Verification[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl70, align: right"]13%[/TD]

[TD="class: xl63"]Total[/TD]

[TD="class: xl73"]8[/TD]

</tbody>

Data:

<colgroup><col style="mso-width-source:userset;mso-width-alt:2925;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:17956;width:368pt" width="491"> <col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:5376;width:110pt" width="147"> </colgroup><tbody>
[TD="class: xl77, width: 80"]Week[/TD]
[TD="class: xl74, width: 101"]Date[/TD]
[TD="class: xl72, width: 79"]Score[/TD]
[TD="class: xl72, width: 491"]Feedback[/TD]
[TD="class: xl72, width: 120"]Order Number[/TD]
[TD="class: xl73, width: 147"]Category[/TD]

[TD="align: right"]43[/TD]
[TD="class: xl68"]11/21/2017[/TD]
[TD="class: xl66, width: 79"]48[/TD]
[TD="class: xl65, width: 491"]Take time an listen[/TD]
[TD="class: xl69"]G006028861[/TD]
[TD="class: xl70"]Delivery / Tracking[/TD]

[TD="align: right"]43[/TD]
[TD="class: xl68"]11/22/2017[/TD]
[TD="class: xl66, width: 79"]100[/TD]
[TD="class: xl65, width: 491"]My in store experience was horrible and embarrassing after a misunderstanding about my rewards Birthday coupon. The service involving this instore was really bad. But my call to customer service was very good and she made up for it[/TD]
[TD="class: xl69"]Not Populated[/TD]
[TD="class: xl70"]Inventory / DC Issue[/TD]

[TD="align: right"]43[/TD]
[TD="class: xl68"]11/22/2017[/TD]
[TD="class: xl66, width: 79"]0[/TD]
[TD="class: xl65, width: 491"]I requested a price matfch and was not given it on all items after being told that it was possible.[/TD]
[TD="class: xl69"]6129290803[/TD]
[TD="class: xl70"]Service / Agent Engage[/TD]

</tbody>

 

[Eric W]

Welcome to the board!

=SUMIFS(Data!C:C,Data!F:F, "Delivery / Tracking",Data!A:A, Summary!C3)

should get you the total of the scores, which you can divide by your COUNTIFS formula. Or just use

=AVERAGEIFS(Data!C:C,Data!F:F, "Delivery / Tracking",Data!A:A, Summary!C3)

 

[DynamiteRave]

I ended up figuring this out.

=AVERAGEIFS(Data!C:C,Data!F:F, "Delivery / Tracking",Data!A:A, Summary!C3)

that fixed it.