COUNTIFS is faster (calculation-wise)

--
Biff
Microsoft Excel MVP


"The Code Cage Team" wrote in
message ...

Sumproduct would be the way to go i think, this example has the dates in
column B and the items in column A:

=SUMPRODUCT((B1:B20=(--("17/11/2008")))*(A1:A20<""))


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile:
http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=31883