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