Vlookup

[TC123]

Hello,

I have one column with numbers ranging from 1 to 11 in it and I have an adjacent column with the number of the month in it (for example, 2 for Feb, 3 for March, 4 for April). The months aren't in any order though and the numbers 1 through to 12 are repeated often. What I want to do is find out how many 1's from the first column are in month 1 in the adjacent column, how many 2's are in month 3 etc. I think I need a VLOOKUP, could anyone advise?

Thank you

 

[T. Valko]

Hello,

I have one column with numbers ranging from 1 to 11 in it and I have an adjacent column with the number of the month in it (for example, 2 for Feb, 3 for March, 4 for April). The months aren't in any order though and the numbers 1 through to 12 are repeated often. What I want to do is find out how many 1's from the first column are in month 1 in the adjacent column, how many 2's are in month 3 etc. I think I need a VLOOKUP, could anyone advise?

Thank you

Try one of these...

Let's assume your data is in the range A2:B20.

Use cells to hold the criteria:

• D2 = 1
• E2 = 1

This formula will work in any version of Excel:

=SUMPRODUCT(--(A2:A20=D2),--(B2:B20=E2))

This formula will work in Excel 2007 and later:

=COUNTIFS(A2:A20,D2,B2:B20,E2)

 

[WaterGypsy]

Try COUNTIFS