Formula Help - SOS

Taylar LaBonte

I am not able to use the date in a formula and I am confused as to why the count is coming out as "0". Please advise!

Trying to count the number of buildings that are not owned by ABC Inc., and contract signed on 02/01/22.

Sameer Karkhanis

Try this, hopefully that works:

=COUNTIFS([Owner]:[Owner], AND(@cell <> "ABC Inc", @cell <> "GreyBird"), [Date]:[Date], DATE(2022, 2, 1) )

Sameer Karkhanis

Try this,

=COUNTIFS([Owner]:[Owner], <>"ABC Inc.", [Date]:[Date], DATE(2022,2,1))

I would suggest to rename the "Date" column to "Contract Date" or so to avoid confusion with the system word/function name "Date".

Taylar LaBonte

@Sameer Karkhanis

How would I change the formula to count the number of buildings that are not owned by ABC Inc. OR GreyBird, and contract signed on 02/01/22?

Thank you so much!

Sameer Karkhanis

Try this, hopefully that works:

=COUNTIFS([Owner]:[Owner], AND(@cell <> "ABC Inc", @cell <> "GreyBird"), [Date]:[Date], DATE(2022, 2, 1) )

Taylar LaBonte

@Sameer Karkhanis

Thank you so much!!