stdev IF...

I am having trouble figuring out a way to calulate the stdev of certain values.
so- what is the stdev of values in column E if the values in column A ="A"?

essentally I need stdev to function like SUMIF.

Im attaching my data.

Also, is there a function that will return the average IF. I am currently summing If, and then dividing by the countIF. is there a function that does the same thing?



Unrelated question:
what exactly does ctrl-shift-enter do?