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
|