Excel CountIfs -- Count text occurrence within a date range

Occasional Visitor

I want to count the occurrence of a text string in one column based on dates in an adjacent column being with a date range.  Example - Count "text" in column A if the adjacent cell date in column B is between July 1 and July 30.  


Does anyone know how best to set that up?



2 Replies


As variant