Thread: Avg Arrays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default Avg Arrays

I have a table 30 rows, 3 columns

Col A is product name (3 products)
Col B is region name (sold in US)
Col C is # Unit for each product (5, 3, 1)


How create a formula that will give me the average number of units for the
sum of the products in a given region.

Output in example should be 9/3 =3

Thanks.