Hello,
I'm working on dashboard that will calculate expected invoices from several clients based on their defined status.
To calculate current expected invoices, I need to apply a SUM of all signed clients but exclude those that are labelled as "Churn" and "Hold"
I thought on something like this: =SUMIF(14:14;OR("<>Churn";"<>Hold");13:13)
Where in,
row 14: I have the client status (Signed, Implementing, Hold, Churn, Invoiving, etc.).
row 13: expected revenue from the client.
For a simple negative condition, the formula is working but when I include the second condition through an OR function, I get 0€ as the outcome.
Any idea what am I missing here?
Thanks!
Bookmarks