LinkBack URL
About LinkBacks
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
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
Last edited by NBVC; 11-13-2008 at 12:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks