COUNTIFS combining AND with OR logic

[WBJ]

In col. A - Dates
In col. B - Statuses (Complete,Partial,NotStarted)

I want to know the number of "Completes" and "Partials" for a given date. That is: COUNTIFS (Dates,"Date",(Status,"=Complete" or Status,"=Partial"))

 

[Jonmo1]

If those are the only 3 possible entries,
then it's easier to say Does Not Equal "NotStarted"
i.e. If it does not equal "NotStarted", it must therefore equal either "Complete" or "Partial"

Try

=COUNTIFS(Dates,"Date",Status,"<>NotStarted")


Hope that helps.

 

[T. Valko]

In col. A - Dates
In col. B - Statuses (Complete,Partial,NotStarted)

I want to know the number of "Completes" and "Partials" for a given date. That is: COUNTIFS (Dates,"Date",(Status,"=Complete" or Status,"=Partial"))

One way...

=SUM(COUNTIFS(Dates,"Date",Status,{"Complete","Partial"}))