To get the count using only the word "limit" or the word "Invalid" as the criteria, you can use the COUNTIF function with wildcard characters.
Assuming the range of your data is A2:A5, you can use the following formula to get the count:
=COUNTIF(A2:A5,"limit")+COUNTIF(A2:A5,"Invalid")
In this formula, the asterisk (*) is used as a wildcard character that represents any number of characters before and after the keyword. By enclosing the keyword in double quotation marks and adding asterisks on both sides, you can search for the keyword in any position within the cell.
The formula counts the number of cells in the range A2:A5 that contain the word "limit" or the word "Invalid" using the COUNTIF function, and then adds the two counts together to get the total count.
In the given example, the formula will return a count of 4 since "limit" appears twice and "Invalid" appears twice in the range.