0

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.
simplified data set

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.

1 Answer 1

1

See these two help files:

Use the COUNTIFS formula, like this, =COUNTIFS(C2:C11,"<"&F2,A2:A11,"="&F1), where F1 is the day of the week and F2 is the current hour. You can either input the current hour manually, or use the formula =NOW()-TODAY().

Formula in context

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .