I have odd problem. I need to count my data based on two criteria that constantly changes. I'm looking to count cells that the day of the week is monday and time is anything done prior to the current hour.
Assuming the above data set I'm looking for a way to count Monday prior to 1215 my answer should be 3. The key is though I want Monday and 1215 to be more of a dynamic value so I can continue looking at this for multiple weeks.