Hi all, I have done some searching and cannot come up with what I need - I would really appreciate your assistance!
I use software at work that automatically generates a monthly COGS report to show our supply usage for each month. I need to find the average item count per location, as illustrated in the attached sample using fruit. I'm looking for a single formula to use in the F column to get the average item per location. I'm sure you can do this with VBA, but I want to avoid VBA if at all possible so other users can understand how this sheet works.
Thanks for your help!
Bookmarks