How do I do a conditional CountIf function

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif on multiple criteria 1
Range headings 0
Countif formula 2
Help with CountIF / SUM 1
countif function 6
SUMIF with criteria "<>" & "=" 4
column to row draging 1
Countif, IF condition is met 2

Top