Hi!

Try this:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=STDEV(IF(A1:A10="whatever",B1:B10))

Biff

"Chris" <chris@msn.com> wrote in message
news:23E3CAA2-58D6-4E0E-828B-AD0E455EE145@microsoft.com...
> How do I use the stdev function in the same manner as sumif?
>
> --
> C