I have a series of jobs (1 row 1 job) with job name, status and due date. I'm trying to count the number of jobs due today (easy enough using =COUNTIF(C:C,TODAY())) but only want the count to reflect jobs which have a status of either "A", "B", or "C" and am struggling with the syntax.
Not sure if this needs a SUMPRODUCT formula nested within the COUNTIF function.
Thanks in advance.
Not sure if this needs a SUMPRODUCT formula nested within the COUNTIF function.
Thanks in advance.