Mean of standard deviations across columns?

Try...

=AVERAGE(IF(D1:D3=1,SUBTOTAL(7,OFFSET(A1:C3,ROW(A1:C3)-MIN(ROW(A1:C3)),0,
1))))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article <ModelerGirl.22pq73_1139069712.1771@excelforum-nospam.com>,
ModelerGirl <ModelerGirl.22pq73_1139069712.1771@excelforum-nospam.com>
wrote:

> I'm looking for an (array) formula that will take the mean of standard
> deviations across several columns given the value of another column.
> For example, I would have
>
> A B C D
> 2 4 2 1
> 2 2 2 1
> 4 2 1 0
>
> I am looking for a formula that will take the mean of the standard
> deviations of A B and C given that column D contains value 1.
>
> Thanks again for everyone's help on previous problems!

Domenic,
Thanks. The only issue is that the columns are not contiguous.

I'm just wondering if there's a way to take an mean of a mean of columns, without calculating a separate column. Subtotal seems to work for groups of columns only.

Which columns are we taking about? Can you specify each range for your
columns?

In article <ModelerGirl.22prta_1139071800.7227@excelforum-nospam.com>,
ModelerGirl <ModelerGirl.22prta_1139071800.7227@excelforum-nospam.com>
wrote:

> Domenic,
> Thanks. The only issue is that the columns are not contiguous.
>
> I'm just wondering if there's a way to take an mean of a mean of
> columns, without calculating a separate column. Subtotal seems to work
> for groups of columns only.