Hi All,

I attach two screen caps about my roster spreadsheet.
excel cap 1.jpg excel cap 2.jpg

I want to add a row below the Night to count the number of leaves per day regardless of the type of leaves?

Could you please suggest a formula?

Thank you very much in advance!

Geoff.