Averaging again

[Reggie]

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 Kabel]

Hi
try the array formula (entered with CTRL+SHIFT+ENTER):
=AVERAGE(IF(A1:A100="girl",B1:B100))

 

[Reggie]

Frank, You are THE MAN!

Thanks as always for pulling my butt out of the fire again!

Vielen Danke,

Reg

 

[Frank Kabel]

Hi
thanks for your feedback )