W
wx4usa
I have a column A for the date MM/DD/YYYY format.
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.
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.