Hi,
In calculation standard deviations I am using the formular
=SUBTOTAL(7;B2:B100) which appears to work nicely when filtering. However, it
also includes cells with "0". Can anyone tell me, how the formular needs to
be changed so only numbers "0" is included?
Many thanks in advance,
Niclas