Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Averaging again
Hello again,
Now, I'm trying to average a range of values but only if data in another column meets certain criteria. If A1:a100="girl" then I want the average of those "girl" associated values in another column. Thanks again, I'm hopelessly lost, Reg |
#2
|
|||
|
|||
Hi
try the array formula (entered with CTRL+SHIFT+ENTER): =AVERAGE(IF(A1:A100="girl",B1:B100)) -- Regards Frank Kabel Frankfurt, Germany "Reggie" schrieb im Newsbeitrag ... Hello again, Now, I'm trying to average a range of values but only if data in another column meets certain criteria. If A1:a100="girl" then I want the average of those "girl" associated values in another column. Thanks again, I'm hopelessly lost, Reg |
#3
|
|||
|
|||
Frank, You are THE MAN!
Thanks as always for pulling my butt out of the fire again! Vielen Danke, Reg -----Original Message----- Hi try the array formula (entered with CTRL+SHIFT+ENTER): =AVERAGE(IF(A1:A100="girl",B1:B100)) -- Regards Frank Kabel Frankfurt, Germany "Reggie" schrieb im Newsbeitrag ... Hello again, Now, I'm trying to average a range of values but only if data in another column meets certain criteria. If A1:a100="girl" then I want the average of those "girl" associated values in another column. Thanks again, I'm hopelessly lost, Reg . |
#4
|
|||
|
|||
Hi
thanks for your feedback :-)) -- Regards Frank Kabel Frankfurt, Germany "Reggie" schrieb im Newsbeitrag ... Frank, You are THE MAN! Thanks as always for pulling my butt out of the fire again! Vielen Danke, Reg -----Original Message----- Hi try the array formula (entered with CTRL+SHIFT+ENTER): =AVERAGE(IF(A1:A100="girl",B1:B100)) -- Regards Frank Kabel Frankfurt, Germany "Reggie" schrieb im Newsbeitrag ... Hello again, Now, I'm trying to average a range of values but only if data in another column meets certain criteria. If A1:a100="girl" then I want the average of those "girl" associated values in another column. Thanks again, I'm hopelessly lost, Reg . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging function | Excel Discussion (Misc queries) | |||
averaging from one selected cell to another | Excel Discussion (Misc queries) | |||
Averaging the last 5 entries in a row | Excel Discussion (Misc queries) | |||
2 part question on averaging | Excel Discussion (Misc queries) | |||
selective averaging | Excel Worksheet Functions |