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