Hello Excel Forum, I need help!
The data below shows how many times each student (i.e. Steve, Martha and James) were either present or tardy for class on various dates. I would like to summarize the data into how many Present occurrences there are per month:
June: 4
July: 3
August: 5
September: 6
'Date' cell reference: A1
Date Steve Martha James
6/1/2018 Present Tardy Tardy
6/10/2018 Present Tardy Tardy
6/20/2018 Present Present Tardy
7/2/2018 Tardy Tardy Tardy
7/4/2018 Present Present Present
8/10/2018 Present Present Present
8/16/2018 Tardy Present Present
9/5/2018 Present Present Present
9/16/2018 Tardy Tardy Tardy
9/22/2018 Present Present Present
Bookmarks