Nested IF, ANDIF, between date ranges Question

[bwhizz]

I am trying to figure out a formula to count the number of occurrences the word "Check" appears between a date range.

For example

Column A Column B
Jan 30 Check
Feb 1 Check
Feb 2
Feb 28 Check
Mar 3
Mar 25 Check

I want to look up the dates by month and count how many times the word "check" appears in the month of February only (2 times)

[daddylonglegs]

Assuming that column A contains true dates

Put 1st of the month to count in D2, e.g. 1-Feb-2008 [you can format as mmm-yy to show just feb-08] then you can use this formula in E2

=SUMPRODUCT(--(A$2:A$100-DAY(A$2:A$100)+1=D2),--(B$2:B$100="check"))

[Ron Coderre]

With your posted data in A1:B7...

here's one approach:
D1: FEB

Please Login or Register  to view this content.

Another alternative would be to use a pivot table.
You could GROUP the date field into months
and count the occurrences of "Check" in Feb.

Does that help?
Post back with more questions.

[bwhizz]

I tried that and it is returning #Value...

here is what i typed.

=SUMPRODUCT(-($A$6:$A$2501-DAY($A$6:$A$2501)+1=B2),-(S386:S393="check"))

[carabale]

Did you figured out the answer?