Hi,
I am using the countif formula in column E to count the number of times the word "WORKING" appears in each row of a worksheet, the formula works but there is one problem.
I only want the formula to count the number of times the word "WORKING" appears in the columns with SHIFT STATUS as their headings; at present the formula will also count if the word "WORKING" also appears in the NOTES columns which i don't want it to do.
Thanks in advance for any ideas.
Ade