Standard deviation

Hello

I am trying to calculate the standard deviation for a range of values but it shouldnt include the zeros for example

Article Code Sub CAT 2016-1 2016-2 2016-3 2016-4 2016-5 2016-6 Standard deviation

17010 BULK COOKED 32 36 0 0 68 16

Can anyone help me please

I have also attached a file

Try this array formula.

=STDEV.P(IF(D3:I3<>0,D3:I3))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.