Sign in to join the conversation:
Good evening:
I am trying to add an OR to the formula below:
=COUNTIFS(Priority:Priority, ="P1", Status:Status, ="Potential")
Potential or Active
Thanks for your help in advance!
Hi
Why don't you use countif and count the factors separately?
Just an idea...
=COUNTIFS(Priority:Priority, ="P1", Status:Status, OR(@cell = "Potential", @cell = "Active"))
You use the OR function in the Criteria section and use @cell references to make them logical statements for the OR.
The same can be done with AND statements which is especially useful when looking at date ranges.
I am working on a sheet where we are tracking the percent complete within a column. The top percent complete formula is =AVG([Percent Complete]2, [Percent Complete]17). The formula in [Percent Complete]2 is =IF(Completed@row = "Completed", "100%", COUNTIF(Completed3:Completed16, "Completed") / 14) The purpose of the…
I am trying to turn off weekly backups, but it's not checked and it shows no history, yet I get backups every week. Is this a bug or there is another place I have to disable it? If it's the right place, why is there no history now?
I'm searching another sheet date column for the max date where two number columns (CID) are equal. It works fine, but if the list of dates contains a blank, I want the formula to return a blank instead of the max date it finds. =MAX(COLLECT({DAFD}, {CID}, @cell = [CID]@row))
