Forum Discussion

Copper Contributor

Jul 30, 2021

Excel CountIfs -- Count text occurrence within a date range

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 i...

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jul 30, 2021

Rick_Bartz

As variant

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