Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
