SUMPRODUCT combined with other functions

Hi,

i'm trying to perform an operation that gets the standard deviation of all open status.

please see my formula.

=SUMPRODUCT(($D$4:$D$1591="open")*1,($H$4:$H$1591)*1,(STDEVA($H$4:$H$1591)))

please assist. thanks a much

Perhaps:

=STDEVA(IF($D$4:$D$1591="open",$H$4:$H$1591))

Confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear around the formula.