Please help: COUNTIF formula with embedded OR statement

jasmine.pena

Can someone help me work out this formula? I am needing to count the items within the portfolio summary who status does not read "Complete" or "On Hold". The current formula I am using is pasted below and is still counting the on hold items.

=COUNTIF({Portfolio Summary | Status}, OR(@cell <> "Complete", @cell <> "On Hold"))

BullandKhmer

COUNTIFS({Portfolio Summary | Status}, <> "Complete", {Portfolio Summary | Status}, <> "On Hold")

jasmine.pena

@BullandKhmer That worked! Thank you!