How to get the count, average, and stdev of numbers in rows of a range that correspond to a particular row identifier?

[Rnkhch]

Hello,

I thought this would be simple, but I'm probably missing something small . I have a few rows of numbers, and at the leftmost cell of each row, there is a row identifier (attached XL2BB). In this example, I'm trying to get the count, average, and stddev of all the numbers that are on the rows that correspond to "A", and I was hoping to do this with formulas that do not require control+shift+enter (I'm trying to avoid control+shift+enter because on large datasets that I typically receive, they slow down the workbook). But so far anything I tried didn't work (even with control+shift+enter) :

Book1
	A	B	C	D	E	F	G	H	I
1
2	A	2	4	6			5.5
3	B	3	4	5
4	A	6	7	8			#DIV/0!	0
5							#DIV/0!	0
6							#DIV/0!	0
7
Sheet1

Cell Formulas
Range	Formula
G2	G2	=AVERAGE(B2,C2,D2,B4,C4,D4)
G4:G6	G4	=AVERAGEIF(B2:D4,A2:A4="A")
H4:H6	H4	=COUNTIF(B2:D4,A2:A4="A")
Dynamic array formulas.

Thanks for any input!

 

[Rnkhch]

P.S. I forgot to mention in my original post that some of the cells in the data range may be blank (blanks from other formulas that evaluate to blank, not just plain blanks), so that makes things a bit more complex

 

[Fluff]

How about

=AVERAGE(FILTER(B2:D4,A2:A4="A"))

 

[Rnkhch]

Yes, incredible, that's exactly what I needed! Thanks much! I also checked the COUNT and STDEV versions of your formula, and they work very well:

=COUNT(FILTER(B2:D4,A2:A4="A"))
=STDEV(FILTER(B2:D4,A2:A4="A"))

 

[Fluff]

You're welcome & thanks for the feedback.