Formula Help - SOS

Taylar LaBonte · 02/10/22

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 · 02/14/22

Try this, hopefully that works:

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

Sameer Karkhanis · 02/10/22

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 · 02/14/22

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 · 02/14/22

Try this, hopefully that works:

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

Taylar LaBonte · 02/14/22

Thank you so much!!

Best Answer