Countifs Formula Help!

bmcmichael48661

 

The current formula is:

=COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") 

I need to count anything that is passed due and not closed, lesson learned or duplicate. I am utilizing a drop down box, too. 

Thoughts?

Branden 

J. Craig Williams

Almost like you said

=COUNTIFS(Due:Due, @cell < TODAY(), Disposition:Disposition, NOT(OR(@cell = "Complete", @cell = "Lesson Learned", @cell = "Duplicate")))

Craig

 

This appears to be a duplicate of this post:

https://community.smartsheet.com/discussion/count-anything-passed-due-excluding-certain-criteria