How do I do a conditional CountIf function

[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!

 

[Jim Thomlinson]

SumProduct is going to probably work for you. Check out this link.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

That page is maintined by Bob Phillips who regularily posts here. Buy him a
beer if you find that page helpful.