Hello! I have a sheet summary for in-progress accounts that uses the Status as the CountIf variable. The problem is that the Status formula includes accounts that the Live Date is equal to or less than today. I need to omit the ones with Live Date equal to today for the sheet summary formula and am really stuck on how to not get an invalid response error.
Here is the current formula: =COUNTIFS(Status:Status, AND(@cell <> "On Hold", @cell <> "Canceled", @cell <> "Inactivity", @cell <> "Live"))
What I really need it to say is: =COUNTIFS(Status:Status, AND(@cell <> "On Hold", @cell <> "Canceled", @cell <> "Inactivity") AND Live Date is greater than today, or is blank, or is an error
I may have to do a helper column for the Live Date, but I am really hoping some AND logic around the live date can be worked in to avoid that.
Thank you for your ideas!! Erica
