How do I do a conditional CountIf function

  • Thread starter Thread starter Kevin
  • Start date Start date
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!
 
Back
Top