View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Count number of 2008 invoices for customers

Have invoices and their dates and customer names.
Looking for a formula to tell me how many invoices were cut for that
customer for the year 2008
Col V is customer name: XYZ
Col U is the invoice year in a helper column: (2008)
Col F is invoice date: (6/16/08)

Above represents the format of the two date fields, Col U is just a 4
digit number.

TIA for your thoughts.
Pierre