Hello all,
I've got a spreadsheet organized roughly like this. Many more rows and 13 sets of columns(plus two total columns) for 2021-Q1 Weeks.
I need a formula for counting dates (they are in text format) across the rows at Date Count, and by row where dates are entered with comma separators (see below, bolded cells)
Hope you can help me here. I'm a bit under the gun to get this to my person tomorrow. :\
Thanks, MIB1019
I've got a spreadsheet organized roughly like this. Many more rows and 13 sets of columns(plus two total columns) for 2021-Q1 Weeks.
I need a formula for counting dates (they are in text format) across the rows at Date Count, and by row where dates are entered with comma separators (see below, bolded cells)
Hope you can help me here. I'm a bit under the gun to get this to my person tomorrow. :\
Thanks, MIB1019
Program | WK1 Dates | WK1 Cost | WK2 Dates | WK2 Cost | WK3 Dates | WK3 Cost | Date Count | Total Cost |
---|---|---|---|---|---|---|---|---|
Program 1 | 28,30,1 | $1500 | 5,7 | $1000 | 11,13,15 | $1500 | Count dates in all Dates columns (8) | Sum of dollar columns |
Program 2 | 29,31 | $1000 | 4,6,8 | $1500 | 12,14,16 | $1500 | Count dates in all Dates columns (8) | Sum of dollar columns |
Program 3 | 28,29,30,31,1 | $2500 | 4,5,6,7,8 | $2500 | 11,12,13,14,15 | $2500 | Count dates in all Dates columns (15) | Sum of dollar columns |
TOTALS | Count 'dates' trimming '," (10) | Sum Function | Count 'dates' trimming '," (10) | Sum Function | Count 'dates' trimming '," (11) | Sum Function | Sum of date count rows (31) | Sum Total Cost |