Formula help

Lori Khoury

Hello

Just wondering if someone could help me with a formula. I need to write a count if formula

Count is Type is Action and Status is not Completed, Decided or Closed. I know how to do on one criteria but how do I add count if not status is not decided or closed.

=COUNTIFS(Type:Type, "Action Item", Status:Status, <>"Completed")

Thanks

Lori Khoury

HI SmartLew - I had to make one minor change but it worked!!! I just had to move the comma after completed.

=COUNTIFS(Type:Type, "Action Item", Status:Status, AND(@cell <> "Completed", @cell <> "Decided", @cell <> "Closed"))

THANK YOU!!!!

SmartLew

Hi Lori,

Use this;

=COUNTIFS(Type:Type,"Action Item",Status:Status,AND(@cell<>"Completed,"@cell<>"Decided",@cell<>"Closed"))

Lori Khoury

HI SmartLew - I had to make one minor change but it worked!!! I just had to move the comma after completed.

=COUNTIFS(Type:Type, "Action Item", Status:Status, AND(@cell <> "Completed", @cell <> "Decided", @cell <> "Closed"))

THANK YOU!!!!

SmartLew

oops sorry for the typo! nice spot. Glad you got it working