Average of Two Columns

  • Thread starter Thread starter BobA
  • Start date Start date
B

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
 
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?
Click to expand...
C P
$199 147p
$359 083
$245 147p
$345 123
$559 147p
Click to expand...

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


Regards
Claus Busch
 
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
Click to expand...

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


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