S
Steve
I have a spreadsheet with data in columns and calculate statistics like
standard deviation using a formula similar to the below.
=IF(ISBLANK('Graph Data'!$R$3),"",STDEV('Graph Data'!$R$2:$R$1000))
If I apply a filter that eliminates some of the rows of data, the result
from the formula doesn't change. Is there a way to calculate and display the
calculation for the visible rows only?
standard deviation using a formula similar to the below.
=IF(ISBLANK('Graph Data'!$R$3),"",STDEV('Graph Data'!$R$2:$R$1000))
If I apply a filter that eliminates some of the rows of data, the result
from the formula doesn't change. Is there a way to calculate and display the
calculation for the visible rows only?