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.
--
HTH...

Jim Thomlinson


"Kevin" wrote:

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!