redart
Board Regular
 Joined
 Oct 15, 2002
 Messages
 246
 Office Version

 2007
 Platform

 Windows
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?.
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 