Excel CountIfs -- Count text occurrence within a date range

Question

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!

sergeibaklan · Answer

Rick_Bartz&nbsp;
As variant
=SUMPRODUCT(
  ISTEXT(ColumnA)*
  (columnDate&gt;=DATE(2021,7,1)
  (columnDate&lt;=DATE(2021,7,31)
 )

hansvogelaar · Answer

Rick_Bartz&nbsp;
Try
&nbsp;
=COUNTIFS(A2:A100,"text",B2:B100,"&gt;="&amp;DATE(2021,7,1),B2:B100,"&lt;="&amp;DATE(2021,7,30))

Forum Discussion

Excel CountIfs -- Count text occurrence within a date range

2 Replies

Resources