Average of Two Columns

[BobA]

Hi, I want to find the average of all of the dollar amounts in column C that correspond to 147p in column P. The answer would be $334.33. Do I use some form of sumproduct for this?

Thanks.

C P
$199 147p
$359 083
$245 147p
$345 123
$559 147p

 

[Claus Busch]

Hi Bob,

Am Tue, 2 Oct 2012 12:24:10 -0700 (PDT) schrieb BobA:

Hi, I want to find the average of all of the dollar amounts in column C that correspond to 147p in column P. The answer would be $334.33. Do I use some form of sumproduct for this?

C P
$199 147p
$359 083
$245 147p
$345 123
$559 147p

what version of Excel do you use?
xl2007 or later try:
=AVERAGEIF(P2100,"147p",C2:C100)
earlier versions try:
=AVERAGE(IF(P26="147p",C2:C6))
and enter the array formula with CTRL+Shift+Enter


Regards
Claus Busch

 

[BobA]

Hi, I want to find the average of all of the dollar amounts in column C that correspond to 147p in column P. The answer would be $334.33. Do I use some form of sumproduct for this?



Thanks.



C P

$199 147p

$359 083

$245 147p

$345 123

$559 147p

what version of Excel do you use?
xl2007 or later try:
=AVERAGEIF(P2100,"147p",C2:C100)


I use 2010, and this formula works fine. Thank you.