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'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
