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