I am making a spreadsheet to log the days my staff work and when they are absent due to illness or emergency.
The days worked I mark with a one and then just add up using the sum function
So far I've just been filling the absence days blue. Is there a formula that will let me count the number of blue cells?
Or can anyone suggest a better way of doing it?
I was taught excel as more of a graph calculation thing rather than an admin thing.
Thanks in advance Excel Gurus
