I want to sum my data in a separate sheet, by week days for my analysis.
The data is entered as DATE, INVOICE NO, CUSTOMER, QUANTITY, DAYS TOTAL.
There will be a new Sheet for every month.
I can extract the day of the week from the above DATEs by using weekdays function but i am unable to sum the whole sheet by a specific day. I mean for eg. i want the total of all SUNDAYS for he moth of January.
(sorry i am unable to upload the file.)
Bookmarks