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 |
Count number of 2008 invoices for customers
=SUMPRODUCT(--(V2:V500="Name"),--(YEAR(F2:F500)=2008))
or using the help column =SUMPRODUCT(--(V2:V500="Name"),--(U2:U500=2008)) note that you need to specify a range if you use excel pre-2007 I would also suggest you put the name in a cell like this =SUMPRODUCT(--(V2:V500=A2),--(YEAR(F2:F500)=2008)) where A2 would hold the customer's name -- Regards, Peo Sjoblom "Pierre" wrote in message ... 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 |
Count number of 2008 invoices for customers
On Sep 5, 10:18*am, Pierre wrote:
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 Figured it out. A PT did the trick. Thanks. Pierre |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com