Thanks, filtering is of course a possibility. I hadn't thought of that.
But is there also a clever way to have this done automatically? I have a
great number of columns where I need to calculate std.dev., so this would be
much preferable, not least as I will also be filtering on other criteria.

Niclas

"Sheeloo" skrev:

Subtotal works only on filtered set... so you should get ther right answer if
you filter out the cells with 0.
It does include cells which are hidden... to exclude hidden cells use 107
instead of 7.

"Niclas" wrote:

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