Hi everyone,
This one is puzzling me, am sure I may have found the solution @ one stage but am losing my mind here lol
I want to check if cells belong to a weekend day, if they do I want to count the content of another cell ie:
A1:I9 is the days of a roster (Fri,Sat,Sun,Mon,Tue,Wed,Thu,Fri,Sat,Sun,Mon,Tue)
In A2:I2 is the number "1" for days I am rostered on,
If upper cells equal a weekend day, I want to check to see if a "1" is in the cell below, if so count it!
example.jpg
Any Help is much appreciated & I thank you in advance,
Chad
Bookmarks