INDEX & MATCH problem (not again!)

[redart]

Hi All,
Can anyone help me with the following INDEX & MATCH problem?
I want the formula in B12 to count only those values (<=1) in the column whose header matches the value in A1. So for the current example the answer would be 3. If A1 contained "cc" the answer would be 2. "m" would give 3, and "a" would give 5. Instead it counts all the values from the desired column to the end column. Any suggestions?.

Book1.xls
	A	B	C	D	E	F
1	c		cc	c	m	a
2
3	m		13	7	4	-10
4	m		18	12	4	-7
5	c		1	-2	-6	-14
6	c		9	3	2	2
7	m		-2	11	7	-5
8	a		10	4	2	-6
9	m		8	0	-4	14
10	m		8	1	0	10
11
12		11
Sheet1

 

[redart]

OK...time to put this one to bed I think. Not sure what the "subrange calculation" was you were referring to Aladin, but I've got it to work anyway. Referring to the sheet below, the formula in cell B12 counts the values in the range D3:F10 - not what I want. Formula in B13 uses the OFFSET function to limit the count to the range D3:D10. Either columns C, D, E, or F gets counted, depending on the value in A1,
Thanks for all the help, and sorry I couldn't explain it better.

Book1.xls
	A	B	C	D	E	F	G
1	c		cc	c	m	a
2
3	m		13	7	4	-10	LS
4	m		18	12	4	-7	LS
5	c		1	-2	-6	-14	LS
6	c		9	3	2	2	LS
7	m		-2	11	7	-5	LS
8	a		10	4	2	-6	LS
9	m		8	0	-4	14	LS
10	m		8	1	0	10	LS
11
12		11
13		3
Sheet1