I am trying to get a formula to add + 1 to a total cell based on the word typed. Example : If I type the word Duty in cells B3:B18 then add + 1 to cell B35. If there are 6 entries of duty then 6 should show in B35. However if there is another word such as Leave then do not count. I would like those tallied in B36. Is there a way to do this?