Excel 2007 : standard deviation

I would like to calculate the standard deviation for Total for all the capture date by item.

So if the item name is the same, it should take the Total for all the Capture Date and calculate the standard deviation.

I would like to figure out a way to do this with a formula. So I can copy the formula all the way down

Is there a function similar to sumif for standard deviation

You want the standard deviation of the dates for a given item? That seems odd ...

In any convenient cell, confirmed with Ctrl+Shift+Enter

=STDEV(IF(B2:B31="A", A2:A31)) (returns 92.22)

How would I be able to recalculate the standard deviation automatically if I filter by Name1 or Name2.

So for example, if I filter by Name 2 by Brown, I want only the items that are filter by Name 2.

So the standard deviation for Item B should be 52 and not 47.9 when Brown is filter.

I would assume you use subtotal and your function above but I can't get it to work

If you filter col B on "B" (or whatever item you like), you can use

=SUBTOTAL(7, Total)

Maybe, probably, but it seems like you're trying for some tortured hybrid of formulas and Autofilter.

Maybe a calculated field for a pivot table, dunno.