Excel CountIfs -- Count text occurrence within a date range

Copper Contributor

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?

 

Thx!

2 Replies

@Rick_Bartz 

As variant

=SUMPRODUCT(
  ISTEXT(ColumnA)*
  (columnDate>=DATE(2021,7,1)
  (columnDate<=DATE(2021,7,31)
 )

@Rick_Bartz 

Try

 

=COUNTIFS(A2:A100,"text",B2:B100,">="&DATE(2021,7,1),B2:B100,"<="&DATE(2021,7,30))