This will return the number of rows that have dates in Column C, that match
your criteria dates in A1 and B1.
=SUMPRODUCT((C1:C100=A1)*(C1:C100<=B1))
You gave no indication that you had specific products to count in the
stipulated time period, and/or where they might be located.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"sumo" wrote in message
...
I need to calculate the number of products despatched between 2 dates.
The date range is in cells A1 and B1 and the date of despatch in cells
C1 to C100. I need a calculation, for ecample that will return a count
of these items in, say, cell D1. Can anyone help?
Thanks
--
sumo
------------------------------------------------------------------------
sumo's Profile:
http://www.excelforum.com/member.php...o&userid=25338
View this thread: http://www.excelforum.com/showthread...hreadid=388167