| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Arrays and Average
I am working w/ a table. Lets say 25 rows/3 columns
Col 1 is product name Col 2 is region name Col 3 is number of units sold I would like to get the average number of units for the sum of the products. So if there are 2 products in the US that sold a combined 15 units, the average would be 7.5. I would like to do this for each region. Please advise on formula. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Using average in two condition arrays... | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
Threaded Mode
