Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number my invoices | Excel Worksheet Functions | |||
how do I consecutively number invoices | Excel Discussion (Misc queries) | |||
Count invoices by day | Excel Discussion (Misc queries) | |||
AUTO NUMBER invoices | Excel Discussion (Misc queries) | |||
top ten customers by transaction count by product | Excel Worksheet Functions |