Sign in to join the conversation:
I'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow".
How would I add "Yellow" to this statement?
=COUNTIFS(Type:Type, "Risk", Status:Status, "Red")
I think you mean OR, since (at least in my system) Status can't be both Red and Yellow at the same time.
=COUNTIFS(Type:Type, "Risk", Status:Status, "Red") + COUNTIFS(Type:Type, "Risk", Status:Status, "Yellow")
or
=COUNTIFS(Type:Type, "Risk", Status:Status, OR(@cell ="Red", @cell ="Yellow")
should work.
Craig
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
