I have 50 rows of data
Down Column A is a region number(1-5) in Cells A2:A51
Across Row 1 is the date in MMMYY format in cells B1:Y1
In the Matrix is an idicator of "X" if a criteria is met
I simply want to count the number of "X" for each Region and Month
I tried: =SUMPRODUCT(--(A2:A51="1"),--(B1:Y1="MAR09"),B2:Y51="X")
The answer should = 3
Somehow I think I need to index the columns going across to get this to work.
I am using Excel 2003
Down Column A is a region number(1-5) in Cells A2:A51
Across Row 1 is the date in MMMYY format in cells B1:Y1
In the Matrix is an idicator of "X" if a criteria is met
I simply want to count the number of "X" for each Region and Month
I tried: =SUMPRODUCT(--(A2:A51="1"),--(B1:Y1="MAR09"),B2:Y51="X")
The answer should = 3
Somehow I think I need to index the columns going across to get this to work.
I am using Excel 2003
Last edited: