Hi
Hope someone can help as this is sadly beyond my Excel know how.
I have a sheet that I need to count occurrences from. I can handle cells with single data but I need to have 1 cell that has days of the week in. In the attached sheet cell C5 has a data validation to select days of the week which is controlled by a little VBA code. Can someone assist with the formula required to search the sheet using criteria in C5 to C9
Any help is greatly appreciated.
Thanks
Bookmarks