I want to get the MEDIAN of the values in F2:Q107 only if the value in
D2107 = D111, how do I do this. I want to do the same thing with MEDIAN.
I don't want to use a pivot table if I can avoid it.

Thanks in advance,
Barb Reinhardt

Try the following formulas, which needs to be confirmed with
CONTROL SHIFT ENTER...

=MEDIAN(IF(D2107=D111,F2:Q107))

and

=STDEV(IF(D2107=D111,F2:Q107))

Hope this helps!

In article gt;,
Barb Reinhardt gt; wrote:

gt; I want to get the MEDIAN of the values in F2:Q107 only if the value in
gt; D2107 = D111, how do I do this. I want to do the same thing with MEDIAN.
gt; I don't want to use a pivot table if I can avoid it.
gt;
gt; Thanks in advance,
gt; Barb Reinhardt

This does what I want, thanks. How do I copy it over a bunch of cells? DO
I have to confirm each and every one?

quot;Domenicquot; wrote:

gt; Try the following formulas, which needs to be confirmed with
gt; CONTROL SHIFT ENTER...
gt;
gt; =MEDIAN(IF(D2107=D111,F2:Q107))
gt;
gt; and
gt;
gt; =STDEV(IF(D2107=D111,F2:Q107))
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; Barb Reinhardt gt; wrote:
gt;
gt; gt; I want to get the MEDIAN of the values in F2:Q107 only if the value in
gt; gt; D2107 = D111, how do I do this. I want to do the same thing with MEDIAN.
gt; gt; I don't want to use a pivot table if I can avoid it.
gt; gt;
gt; gt; Thanks in advance,
gt; gt; Barb Reinhardt
gt;

I have cells in F2:Q107 that are blank and the calculations appear to treat
those as zeros. What needs to be changed.

quot;Domenicquot; wrote:

gt; Try the following formulas, which needs to be confirmed with
gt; CONTROL SHIFT ENTER...
gt;
gt; =MEDIAN(IF(D2107=D111,F2:Q107))
gt;
gt; and
gt;
gt; =STDEV(IF(D2107=D111,F2:Q107))
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; Barb Reinhardt gt; wrote:
gt;
gt; gt; I want to get the MEDIAN of the values in F2:Q107 only if the value in
gt; gt; D2107 = D111, how do I do this. I want to do the same thing with MEDIAN.
gt; gt; I don't want to use a pivot table if I can avoid it.
gt; gt;
gt; gt; Thanks in advance,
gt; gt; Barb Reinhardt
gt;

In article gt;,
Barb Reinhardt gt; wrote:

gt; This does what I want, thanks.

You're welcome! Glad I could help!

gt; How do I copy it over a bunch of cells?

If you're copying the formula down the column...

=MEDIAN(IF(D2107=D111,F2:Q107))

If you're copying the formula across the row...

=MEDIAN(IF(D2:D107=D111,F2:Q107))

gt; DO I have to confirm each and every one?

No, you only need to confirm with CONTROL SHIFT ENTER for the first
cell, then you can copy or drag the formula down or across...

Hope this helps!

Try...

=MEDIAN(IF(D2107=D111,IF(F2:Q107lt;gt;quot;quot;,F2:Q1 07)))

Hope this helps!

In article gt;,
Barb Reinhardt gt; wrote:

gt; I have cells in F2:Q107 that are blank and the calculations appear to treat
gt; those as zeros. What needs to be changed.

Now why didn't I think of that. I tried using IF(AND()) and it didn't like
what I had.

quot;Domenicquot; wrote:

gt; Try...
gt;
gt; =MEDIAN(IF(D2107=D111,IF(F2:Q107lt;gt;quot;quot;,F2:Q1 07)))
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; Barb Reinhardt gt; wrote:
gt;
gt; gt; I have cells in F2:Q107 that are blank and the calculations appear to treat
gt; gt; those as zeros. What needs to be changed.
gt;