I am trying to count the number of occurrences of a value >0 and <=10 from C3:C9330, but I would like to count them dependent on whether the recorded date in B3:B9330 is a weekday or a weekend, i.e. count the number of times a value of 0-10 occurs on weekdays, and how many time it occurs on weekends. I have tried COUNTIFS formulas but I can't seem to get the criteria correct to count only if the date in column B is a weekday (or a weekend). Does anyone know how to do this?

Cheers.