View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ermeko ermeko is offline
external usenet poster
 
Posts: 28
Default Sumproduct with date range

Hi,
I want to count an "A" column where the column "B" is between a given date.
The date in column B has a date and a time("dd-mm-yyyy hh:mm:ss"). The date
arguments in the sumproduct are in the "dd-mm-yyyy" form. The formula should
find "like products", not the exact match.
Thank you,
ermeko