Count Project Categories + Count if Before a date

Lauren Croft

Hi!

I want to work out a total number of files we have overdue. I have got as far as adding up all projects that do not include the category completed using:

=COUNT([Project Category]:[Project Category]) - COUNTIF([Project Category]:[Project Category], "Complete")

I now want it to not include the project category "With Consultant" too.

Then, i want it to only count the ones remaining if another column called date Completion date is before the start of the month.

Thanks for your help in advance!

Lauren Croft

Picture of sheet for reference

Paul Newcome

Try:

=COUNTIFS([Project Category]:[Project Category], AND(@cell <> "Complete", @cell <> "With Consultant"))

Lauren Croft

Thank you that worked! Do you know how I can now add in for it to only count ones where the Completion date is before the current month

Paul Newcome

You would add a new range/criteria set along the lines of

=COUNTIFS(…………….., [Completion Date]:[Completion Date], @cell < DATE(YEAR(TODAY()), MONTH(TODAY()), 1))