Jul 30 2021 12:07 PM
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!
Jul 30 2021 12:26 PM
As variant
=SUMPRODUCT(
ISTEXT(ColumnA)*
(columnDate>=DATE(2021,7,1)
(columnDate<=DATE(2021,7,31)
)
Jul 30 2021 12:36 PM