Help with formula please

[Eamon]

Hi,



Can someone please offer a solution for this problem.



I have a worksheet using columns A to AE

Rows 1 to 1000+

In column D row 7 down I have price i.e. 4.50, 12.00, 26.00, 5.50 etc!

In Z3, I am returning the average of all prices in column D, i.e.
=AVERAGE(D)

In column K I have a reference to each price i.e. "W" or "R" etc!

What I am trying to do in cell AC3 is return the average price from column
D. but only for the prices that have "W" in the same row in column K



Regards,



Eamon

 

[CLR]

=SUMIF(K:K,"w",D)/COUNTIF(K:K,"w")

Vaya con Dios,
Chuck, CABGx3

 

[Eamon]

Thank you, works perfect.

Best regards,
Eamon

=SUMIF(K:K,"w",D)/COUNTIF(K:K,"w")

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

You're welcome Eamon..........happy to help

Vaya con Dios,
Chuck, CABGx3