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?

Week:	43
Dates:	11/19/2017	11/25/2017
Issue	Score	Total	% of Feedback
Delivery / Tracking		1	13%
Inventory / DC Issue		1	13%
Service / Agent Engage		1	13%
Return / Exchange		1	13%
Loyalty / Rewards		1	13%
Discount / Promos		1	13%
Change / Cancel		1	13%
Order Verification		1	13%
Total		8

<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>
</tbody>

Data:

Week	Date	Score	Feedback	Order Number	Category
43	11/21/2017	48	Take time an listen	G006028861	Delivery / Tracking
43	11/22/2017	100	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	Not Populated	Inventory / DC Issue
43	11/22/2017	0	I requested a price matfch and was not given it on all items after being told that it was possible.	6129290803	Service / Agent Engage

<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>
</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.