SUM Daily Totals from Text Dates with Text Day Criteria
See Mr Excel and excelisfun use two methods to
1. Add up daily sales from a template that is not setup properly: multiple columns instead on one column, criteria set at text and dates set as text values rather than serial number dates.
2. See these functions: WEEKDAY, ISBLANK, NOT and SUMIF