How do I use the stdev function in the same manner as sumif?
B Biff Oct 13, 2005 #2 Hi! Try this: Entered as an array using the key combo of CTRL,SHIFT,ENTER: =STDEV(IF(A1:A10="whatever",B1:B10)) Biff
Hi! Try this: Entered as an array using the key combo of CTRL,SHIFT,ENTER: =STDEV(IF(A1:A10="whatever",B1:B10)) Biff
