Count number of 2008 invoices for customers


P

Pierre

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
 
Ad

Advertisements

P

Peo Sjoblom

=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
 
Ad

Advertisements

P

Pierre

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top