Sumproduct or Countif - Counting Occurances within a Date Range

  • Thread starter Thread starter J_L_G
  • Start date Start date
J

J_L_G

I have a spreadsheet that looks a little like this:

A B C
1 LA 24974 October-08
2 LM 24977 October-08
3 LM 24977 November-08
4 LM 24978 November-08

Colum C is a DATE, which is formatted to "mmmm-yy"

I need to count the number of occurances of each of the values in Colum A,
per month.

The resutls would look like this:

OCTOBER NOVEMBER
LA 1 0
LM 1 2
 
=SUMPRODUCT(--(Sheet1!$A$1:$A$10=Sheet2!$A2),--(TEXT(Sheet!$B$1:$B$10,"mmmm")=Sheet2!B$1))

copy down and across.
 
Thanks!

That's a great tip.

Bob Phillips said:
=SUMPRODUCT(--(Sheet1!$A$1:$A$10=Sheet2!$A2),--(TEXT(Sheet!$B$1:$B$10,"mmmm")=Sheet2!B$1))

copy down and across.

--
__________________________________
HTH

Bob
Click to expand...
 
Back
Top