Help with formula please
 

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: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

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

Vaya con Dios,
Chuck, CABGx3


"Eamon" wrote in message
...
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: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

Thank you, works perfect.

Best regards,
Eamon

"CLR" wrote in message
...
=SUMIF(K:K,"w",D:D)/COUNTIF(K:K,"w")

Vaya con Dios,
Chuck, CABGx3


"Eamon" wrote in message
...
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: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

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

Vaya con Dios,
Chuck, CABGx3


"Eamon" wrote in message
...
Thank you, works perfect.

Best regards,
Eamon

"CLR" wrote in message
...
=SUMIF(K:K,"w",D:D)/COUNTIF(K:K,"w")

Vaya con Dios,
Chuck, CABGx3


"Eamon" wrote in message
...
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: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