Summary Task formula for COUNTIF Before TODAY and Status IS NOT "Not Started"

Lisa Matthews

Hello,

I'm looking for a summary task formula to count a row if the date is before today and Status value is NOT "Location Not Started". I've tried a few formulas and can't get to a working one. This is the last one I tried and getting and "Incorrect Argument" error message:

=COUNTIFS([Confirmed Install Date]:[Confirmed Install Date], <=TODAY(), IF(NOT([Combined Status]:[Combined Status] = "Location Not Started")))

Thank you for your help!

--Lisa M.

Eric Law

@Lisa Matthews your formula is close but I tweaked it a little, should work now.

=COUNTIFS([Confirmed Install Date]:[Confirmed Install Date], <=TODAY(), [Combined Status]:[Combined Status], NOT(@cell = "Location Not Started"))

Austin Smith

@Lisa Matthews

Try

=COUNTIF([Confirmed Install Date]:[Confirmed Install Date], <=TODAY()) - Countif([Confirmed Install Date]:[Confirmed Install Date], <=TODAY(), [Combined Status]:[Combined Status] = "Location Not Started")

Total count minus the ones you don't want

Lisa Matthews

Hi @Austin Smith ,

Thank you for looking at this. I tried this formula (copied + pasted) and still getting the same error message: "Incorrect Argument Set", not sure why? Wanna have another look at it?

Thank you so much!

-Lisa

Eric Law

@Lisa Matthews your formula is close but I tweaked it a little, should work now.

=COUNTIFS([Confirmed Install Date]:[Confirmed Install Date], <=TODAY(), [Combined Status]:[Combined Status], NOT(@cell = "Location Not Started"))

Lisa Matthews

@Eric Law

This formula worked perfectly!

Thank you so much!

-Lisa