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(Sheet1!L:L,"006*",Sheet1L:L,"007*") counts the number of rows in column L whose value starts with 006 and with 007 at the same time. That is an impossible combination, so the result is 0.
You WANT
=COUNTIF(Sheet1!L:L,"006*")+COUNTIF(Sheet1L:L,"007*")
or
=SUMPRODUCT(COUNTIF(Sheet1!L:L,{"006*","007*"))
- Thank you so much. I'll tuck the second option in my pocket too 🙂
