Count IF in a Date Range, See Example

[Barrelroll]

Hey all,

I'm trying to get a COUNTIF inside a date range. So basically how many times is did "TEST1" occur in JAN.

eg:

IF A1 contains JAN (or between 01-jan-10 to 31-jan-10) and B2 = TEST1
D1++

Hope that's clear.

Thanks in advance.

[ConneXionLost]

In your spreadsheet example, try:

Please Login or Register  to view this content.

Cheers,

[Barrelroll]

In your spreadsheet example, try:

Please Login or Register  to view this content.

Cheers,

Your a champ! thanks mate.