Sign in to join the conversation:
I wanted to countif number on below example. it should bring the count 3.
Example :
Cell-2 - "Fail - Item not available'"
Cell-2 - "Fail - item out of stoke"
Cell-3 - "Fail - routed to wrong one"
I think what you are asking for is to check for the "Fail" at the beginning of the text string.
If so, this
=COUNTIF(Status1:Status10, LEFT(@cell, 4) = "Fail")
would count the first 10 rows of the [Status] column.
This would count the whole [Status] column
=COUNTIF(Status:Status, LEFT(@cell, 4) = "Fail")
I hope this helps.
Craig
