countif if status "in progress" and occurred in the past

andhou

Hi,

I want to create a report that provides the number of items that are "in progress" and their finish date is in the past (past from today). For this report, I have to reference another sheet. This is the formula I'm using but I receive an error message. Does anyone have any idea how to correct? Thank you in advance.

=COUNTIF(reference another sheet, "in progress"), AND (reference another sheet TODAY( -1)).

andhou

Thank you James! It worked!

James Keuning

use COUNTIFS:

=COUNTIFS({in progress REFERENCE Range 1}, "in progress", {in progress REFERENCE Range 2}, <TODAY())

andhou

Thank you James! It worked!