Hi - i'm new to this forum so please forgive me if this has been covered elsewhere, but i couldn't find it...

I need to count rows that meet 2 criteria.

I have seen this help page

http://www.ozgrid.com/Excel/count-if.htm

but that counts rows with "criteria 1" OR "criteria 2"...

I need to count rows that fulfill "criteria 1" AND "criteria 2"

ie - count the rows that have todays date AND a cell that says "COMPLETE"

ideally it would be as easy as "=countif(A:F,"today()","COMPLETE") but that doesn't work... any way around this???

Thanks!

I need to count rows that meet 2 criteria.

I have seen this help page

http://www.ozgrid.com/Excel/count-if.htm

but that counts rows with "criteria 1" OR "criteria 2"...

I need to count rows that fulfill "criteria 1" AND "criteria 2"

ie - count the rows that have todays date AND a cell that says "COMPLETE"

ideally it would be as easy as "=countif(A:F,"today()","COMPLETE") but that doesn't work... any way around this???

Thanks!

## Comment