D
doco
Given the following Column headers
Date Month ListPrice SalePrice Ratio
I can use the following [ COUNT(IF(...)); AVERAGE(IF(...)); MEDIAN(IF(...)),
etc A array functions to gain the following
TERM COUNT MEAN
MEDIAN
1 {COUNT(IF(TERM=Month,Ratio))} etc etc
2 ...
3 ...
4 ...
5
6
7
8
9
10
11
12
What I would like to know if there is a way to use
SUBTOTAL(Integer,IF(...)). I have other column headers in the original list
that are usefull to use DATA | FILTER | AUTOFILTER and would like the lower
array to update automatically after using autofilter drill downs.
TIA
Date Month ListPrice SalePrice Ratio
I can use the following [ COUNT(IF(...)); AVERAGE(IF(...)); MEDIAN(IF(...)),
etc A array functions to gain the following
TERM COUNT MEAN
MEDIAN
1 {COUNT(IF(TERM=Month,Ratio))} etc etc
2 ...
3 ...
4 ...
5
6
7
8
9
10
11
12
What I would like to know if there is a way to use
SUBTOTAL(Integer,IF(...)). I have other column headers in the original list
that are usefull to use DATA | FILTER | AUTOFILTER and would like the lower
array to update automatically after using autofilter drill downs.
TIA