HI All,
I want to add up the number of time the word "IN" appears in a row. THere will be other words on the cells in the same row which should not return a value.
WORDS
IN = 1
H = 0
SICK = 0
OFF = 0
I am creating a staff rota and trying to make it simple to complete by copying entering the above words in the cells and end of the row will calculate the actual hours required.
HELP
Bookmarks