K
Kevin
Column A is dates
Column B is text
I know how to do countif functions to find a date range (where G1 and H1 are
dates)
=COUNTIF(A1:A8,">= "&G1)-COUNTIF(A1:A8,">="&H1)
How do I also look in column B for a certain text value (example: 'No') and
if the row is in the date range but has a 'No' in column B, then it is NOT
counted?
Thanks!
Column B is text
I know how to do countif functions to find a date range (where G1 and H1 are
dates)
=COUNTIF(A1:A8,">= "&G1)-COUNTIF(A1:A8,">="&H1)
How do I also look in column B for a certain text value (example: 'No') and
if the row is in the date range but has a 'No' in column B, then it is NOT
counted?
Thanks!