Thread: Countifs -Count no of times products have been sold on particular
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The Code Cage Team[_37_] The Code Cage Team[_37_] is offline
external usenet poster
  
Posts: 1
Default Countifs -Count no of times products have been sold on particular

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

Reply With QuoteReply With Quote