Using Countif and Offset

Hello

Im having trouble using the countif with offset. i want to count a criteria but I only want to count it from a certain date, once I have sorted the dates in ascending order.

To locate the starting row for the date I have used the match function, no problem with that.

The problem arises when I try using the row reference in the countif and offset function.

Basically I would like to count the number of times the a criteria is met on a a given date (this will always be yesterday and the match function will locate my starting point)

The columns with he dates in ascending order is column C, The criteria I would like to match it up is in column H.

In a nut shell I want the countif and offset function to locate the row that yesterdays date starts, use the offset function to create the array and count the number of times a defined criteria occurs on that day.


Thanks in advance