Assuming your input sheet is called Day Shift (i.e. has spaces) you
use:

=COUNTIF('Day Shift'!B5:B46,"N")

Notes: The single quotes around the sheet name are only necessary if
the sheet name contains spaces. Otherwise they can be omitted.
Also, I cannot see any reason in this context for multiplying with 1.

HTH
Kostis Vezerides