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.

Avg Arrays
 

duplicate post
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"PAL" wrote:

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.

Avg Arrays
 

Hi,

By the way you example bothers me "(5+3)/2 =4.5" ?? should be 4.

In 2007 you can use AVERAGEIF

=AVERAGEIF(B1:B9,"US",C1:C9)

or if you enter the region in D1

=AVERAGEIF(B1:B3,D1,C1:C3)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"PAL" wrote:

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.