I'm using the following formula, but I do not want it to take into account blank cells or null cells.
=COUNTA(Monday!L5:L11,Tuesday!L5:L11,Wednesday!L5:L11,Thursday!L5:L11,Friday!L5:L11,Saturday!L5:L11,Sunday!L5:L11)
The above cells also have the following formula...