“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hi, I have an excel SS that consists of a list of names - vertically, and days of the month - horizontally.
the SS is used for shift allocation. At the end of each row, I want to add up how many "OC" shifts someone has just at the weekends, How many weekday "OC"
I'm struggling to find a formula that will allow me to isolate just the weekends or weekdays..
I tried =COUNTIF(H6:I6O6:P6V6:W6AC6:AD6,"OC")
in that H6:I6 and so on are the cells corresponding to the weekend for each person.
There must be a way around it! Help please!

Solved by G. F. in 16 mins

how to i know how many games were released in a certain month? eg. january 2000, febuary 1600

Solved by S. Q. in 17 mins

How can I find out how many of each drink was bought in each month?

Solved by B. H. in 25 mins

I need a formula to figure out how many males and females (gender) join in each department in one month.

Solved by V. U. in 25 mins

i'm working in google spreadsheets right now, and I'm trying to display how many accounts will be passed off to an account manager next month. I want to find a formula that I can do to count the column that holds the day of pass-off and then display how many of those dates are in the next month (I want it to be dynamic based on the current month)

Solved by E. E. in 26 mins