Forum Discussion
Solved
COUNTFS/COUNTIF not working with cells that have multiple values
I cannot figure out a formula that will work for my needs. I need to total the number of times a specific type of error occurs in a specific range of cells. I can total just fine if I use =COUNTIF(e4:...
- Use wild card character * before and after the criteria like this and you will get the desired count...
=COUNTIF(E4:E200,"*Income*")
Use wild card character * before and after the criteria like this and you will get the desired count...
=COUNTIF(E4:E200,"*Income*")
=COUNTIF(E4:E200,"*Income*")
- THANK YOU! That worked! You’ve saved me another night of sleep lost. 🙂
You're welcome ash-701! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as Best Response to mark your question as Solved.
