I need to differentiate between 8 and 12 in count if formula

I have been using a count if formula =COUNTIF(B36:AF36,"?")*12 to add up the hours worked each month.
at the end of a row. In the spread sheet I use D for day shift and N for night shift "?" the *12 for 12 shifts.

20 21 22 23 24 25 26 27 28 29 30 31 Hours
W T F S S M T W T F S S Total W
N N N N D D D D 96(=COUNTIF(B36:AF36,"?")*12)


my shift pattern has now changed and I will be doing an 8 hour shift as well as normal 12 hour shifts.

I would like to use E for eight hour shifts.

I have tried to put an IF function in to differentiate between the E and the D,N . But am unable to
get it to calculate properly. should I be using a different function for this?

As you can probably tell I am new to functions can work with basics but would greatly appreciate some assistance with this

thanks in advance Paul

Hi that was fantastic, so quick and fixed problem, thank you very much. Wonder why I seem to look for the complicated way of doing things.