Results 1 to 4 of 4

Thread: Need Help with Average Percentages Based on Criteria

  1. #1

    Need Help with Average Percentages Based on Criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Good morning,

    I think you can use AVERAGEIFS:

    =AVERAGEIFS(L2:L3975,C2:C3975,"Raw Material")

    Best of luck,

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try using AVERAGEIF

    e.g. =AVERAGEIF(WSK!C2:C3975,"Raw Material", WSK!L2:L3975)


  4. #4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •