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

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

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


.

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


.