Forum Discussion

ash-701's avatar
ash-701
Copper Contributor
Jul 28, 2021
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:...
excel
Formulas and Functions
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Jul 28, 2021
    Use wild card character * before and after the criteria like this and you will get the desired count...

    =COUNTIF(E4:E200,"*Income*")
ash-701's avatar
ash-701
Copper Contributor
Jul 29, 2021
THANK YOU! That worked! You’ve saved me another night of sleep lost. 🙂
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Jul 29, 2021

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.