Standard Error IF range, criteria, StandardError_range

[nostradamus]

Hello, I have a range if question to calculate Standard Error
I need a Standard Error formula in cell E6 (for Control from Column A) and cell E7 (for Impact from Column A) to return the values given. I have included the Standard Error formula in cell F6

I am including average formula in cell E2 and cell E3 to get a general idea of what I am trying to get.

Thank you

 

[Fluff]

How about

=STDEV(IF($A$2:$A$12=D6,$B$2:$B$12))/(SQRT(COUNTIF($A$2:$A$12,D6)))

 

[nostradamus]

Thank you @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.