If you're worried about the format for dates, you can use:

=sumproduct(--(I1:I1000="Denmark"),--(D1:D1000date(2005,03,01)),
--(D1:D1000<date(2005,03,31))

(and didn't you drop a closing paren from that middle portion?)

And another option:

=sumproduct(--(I1:I1000="Denmark"),--(text(D1:D1000,"yyyymm")="200501"))

But that will suffer from yyyymm. The OP will have to use whatever that
language uses for yyyy and mm.



bj wrote:

try
=sumproduct(--(I1:I1000="Denmark"),--(D1:D1000datevalue("01/03/2005"),--(D1:D1000<datevalue("31/03/2005"))

Note depending on your version of excel, you may have to play with the
format of the dates.
I normally prefoer to put the dates outside the Sumproduct and reference them.

"Jim Rennie" wrote:


Hi

The spreadsheet im using has date values in Column D and country names
in column I and im am trying to count rows of entries for each country
name entered each month.

The criteria example for March is....

Count column I = Denmark where Column D is between 01/03/2005 and
31/03/2005 inclusive

Any help would be appreciated

Thanks....Jim


--
Jim Rennie
------------------------------------------------------------------------
Jim Rennie's Profile: http://www.excelforum.com/member.php...o&userid=24461
View this thread: http://www.excelforum.com/showthread...hreadid=380571



--

Dave Peterson