Hi Everyone,
I have an issue with a model I am building. I can't figure out how to pull the average for values that correspond to different names. If I have Column A with company names repeating in random order, and column B with their associated value, I need to average the associated values for each company. However, I need it to ignore the zeros and blanks, otherwise the data is skewed.
I have been able to pull the averages with an array formula {=AVERAGE(IF(A$21:A$64 = A4, B$21:B$64)))}, but not exclude the zeros. Any help is greatly appreciated. Attached is an example.
Thanks,
Adam
Bookmarks