| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Return multiple values in one cell doing a single value lookup | Excel Discussion (Misc queries) | |||
| single lookup value with multiple results | Excel Worksheet Functions | |||
| create a list of single values from multiple values | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
![Gary Brown[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
