Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |