I want to use LOOKUP to average multiple values for a single crite
Assumptions:
Col A - Vendor
Col B - Item
Col C - Cost
Col D - Cost+Tax
Col E - Cost/oz.
Data starts in Row 2
Data range is A2:E8
Criteria - Item - is in cell G2
Formula:
=SUMIF(B2:B8,G2,E2:E8)/COUNTIF(B2:B8,G2)
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
"N_baker" wrote:
Okay, my data set has...
Columns: Vendor Item Cost Cost+Tax Cost/oz.
The items come from multiple vendors...
What would be the easiest way to lookup the items individually and calculate
the average cost/oz for each item, summarizing the averages in a separate
worksheet?
|