Forum Discussion
Countifs returning all rows with 006, 007 in
Hey all! I'm trying to return a count of all rows in column L that start with 006 and 007. My formula is as below =Countifs(Sheet1!L:L,"006*",Sheet1L:L,"007*") My formula sits on a different shee...
COUNTIFS(...) will AND the conditions meaning both or all the conditional must be true. Since none of the rows can start with 006 AND 007 at the same time you get 0 try this instead:
=Countifs(Sheet1!L:L,"006*") +Countifs(Sheet1L:L,"007*")
=Countifs(Sheet1!L:L,"006*") +Countifs(Sheet1L:L,"007*")
- Amazing! Thank you. It works and my blood pressure is slowly lowering!
