Sumproduct or Countif - Counting Occurances within a Date Range

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
 
B

Bob Phillips

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

copy down and across.
 
J

J_L_G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct and Networkdays Together 2
Counting items with a specific quanitifier in a date range 3
Sum If range of dates date range, sum totals 7
Month days over a time period 5
Allocate an income payment over a date range (tax years) 7
counting the occurances for specific dept within a given time peri 1
Counting # of entries for each month, in a specific status 3
count on 3 criteria 3

Top