I am looking to average percentages in column L2:L3975 based on their criteria in C2:C3975. The criteria are raw material, packaging, and finished good. So what I am trying to do is track the accuracy of my inventory based on these 3 categories. Currently I have =IF(WSK!C2:C3975="Raw Material", AVERAGE(WSK!L2:L3975), ""). I think my logic is incorrect and have been trying a sumproduct formula but have not had results yet. If anyone has suggestions on how to average my percentages based on a text that would be very helpful. If examples are needed I can upload a spreadsheet.Thanks.
Need Help with Average Percentages Based on Criteria
- Thread starter Cliving
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
Try using AVERAGEIF
e.g. =AVERAGEIF(WSK!C2:C3975,"Raw Material", WSK!L2:L3975)
e.g. =AVERAGEIF(WSK!C2:C3975,"Raw Material", WSK!L2:L3975)
Thank you! I knew that my logic was incorrect and both of these functions that were posted do the trick. I appreciate all the help I did not expect it was that easy.Thank you both again (my warehouse manager will be happy).Have a good holiday