Sign in to join the conversation:
Trying to get a value for columns with Yes. Not total but countif(or(col 1 "yes, col 2 yes etc.
I've tried every variation of this: =IF(OR(COUNTIF([O2 under 5 lpm]1, "yes", ([O2 over 5 lpm]1, "yes"))
Try
=Countif([O2 under 5 lpm]1, "yes") + Countif([O2 over 5 lpm]1, "yes")
That will count all yesses in the first column and then add the count of all yesses in the 2nd column.
but i don't want a total for both columns, just a single value if either column has yes. the OR statements are not working. and i even copied a working if(or from another sheet.
Still not 100% clear on what you're after, so I've given 2 options.
This will give you a total count for both columns if either contains a "Yes":
=COUNTIF([O2 under 5 lpm]:[O2 over 5 lpm], "Yes") - COUNTIFS([O2 under 5 lpm]:[O2 under 5 lpm], "Yes", [O2 over 5 lpm]:[O2 over 5 lpm], "Yes")
This will give you a value of 1 for each row (i.e. in a cell either side of your values) where a "Yes" occurs:
=IF(OR([O2 under 5 lpm]1 = "Yes", [O2 over 5 lpm]1 = "Yes"), 1, "")
Kind regards,
Chris McKay
Can you post a screenshot showing what data you are working with so we can better understand what you are trying to do?
Yep, I'm with Mike here. Still not clear on what you're after. A screenshot would be ideal.
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
