Driving myself nuts trying to create a chart.
Not sure if it can be done and can’t find a video on how to do it if it’s possible.
I have a spreadsheet with dates and totals of how much I got paid each day at work.
The dates are like this in Column A
12-3-2023 Sunday $10
12-4-2023 Monday $20
12-5-2023 Tuesday $20
12-6-2023 Wednesday $15
12-7-2023 Thursday $30
12-8-2023 Friday $50
12-9-2023 Saturday (OFF)
12-10-2023 Sunday (OFF)
12-11-2023 Monday $23
12-12-2023 Tuesday $43
12-13-2023 Wednesday (OFF)
12-14-2023 Thursday $78
12-15-2023 Friday $32
12-16-2023 Saturday $43
12-17-2023 Sunday $23
Other entries are in but Column “R” shows the total for each day
How can I make a chart that shows just all the “Sundays” with the Totals from all Sundays
All the Mondays with the totals from all the Mondays
and so on …
I can only select a range but is there any way I can select just the cells that show “Sunday”, “Monday” etc …