Given the way that data is entered into this spread sheet, is there a way to automate the summary at the bottom of the page?
Every time a specific job is preformed on a bus shelter (garbage removal, wash, etc) a representative code is entered into the cell denoting the shelter and the date. The way the data is entered is that if say a bus gets garbage removed (2) and cleaned (3), it is entered as 2.3 At the bottom of the page i have to fill out a summary that counts how many different things were done each day ie. how many washes (2s) how many cleans (3s) etc. Im having a lot of trouble with this so any help would appreciated, thanks in advance
shelterlog.xlsx
Bookmarks