Subtotal

  • Thread starter Thread starter Kimme
  • Start date Start date
K

Kimme

Hi,
We have the Min and Max subtotal for example:
=subtotal(5,A1:A100)
=subtotal(4,A1:A100)
Do we have subtotal, funtion_number for Median, first
Quartile and third Quartile?

Thanks,
 
Hi,
We have the Min and Max subtotal for example:
=subtotal(5,A1:A100)
=subtotal(4,A1:A100)
Do we have subtotal, funtion_number for Median, first
Quartile and third Quartile?

Thanks,
Click to expand...

You will find the Subtotal functions listed if you go to HELP for Subtotals.


--ron
 
Thanks for your Reply
Yes, I found
1 Average
2 Count
3 CountA
4 Max
5 Min
6 Product
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP
I am looking for the subtotal for Median, first quartile
and third quartile? I am using this for Boxplot and
whisker chart.
Thanks,
 
Hi
for the Median try the following array formula entered with
CTRL+SHIFT+ENTER (assumption: column A contains your values):
=MEDIAN(IF(SUBTOTAL(3,OFFSET(INDEX($A$1:$A$100,1,1),ROW($A$1:$A$100)-RO
W(INDEX($A$1:$A$100,1,1)),0))=1,$A$1:$A$100))
 
Thanks for your Reply
Yes, I found
1 Average
2 Count
3 CountA
4 Max
5 Min
6 Product
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP
I am looking for the subtotal for Median, first quartile
and third quartile?
Click to expand...

Well, as you see, there is no subtotal for those functions.

Perhaps more information about your data might help in solving your problem
using some other method.


--ron
 
Hi
works for me. what is the exact error you got. Also have you entered
the formula as array formula?
 
Back
Top