W

#### wx4usa

I need to have a sumproduct formula look thru the database and return

sales totals for salesperson by month, day and year separately.

For example:

Column

A is date

B is salesperson

C is sales

On a separate page in the workbook, I have a report with these

selection criteria...

A1 is salesperson

A2 is month

A3 is year

I need a formula to return sales for this salesperson for the month

and for the year. Looking ahead, the report/database will span

several years.

Also, is there a way to sumproduct sales by day of the week such as

Tuesdays using the mm/dd/yyyy format?

I seem to struggle with dates and sumproduct.

Any help would be greatly appreciated.