Excel sum value... [Solved/Closed]

Ask a question anazar 2Posts Wednesday February 3, 2016Registration date February 3, 2016 Last seen - Last answered on Feb 3, 2016 at 10:58 PM by anazar

I would like to know how to do the below mentioned formula I have tried but not resulted.
Excel - Sum value in column when cells contains certain text


Please given example through excel.


Abdul Nazar
plus moins
Thank you very much, this issue has been solved.


Abdul Nazar.
Was this answer helpful?  
plus moins
Hi Abdul,

Really, I should delete this as it is clearly a result from this link ...

However, I also had an issue when I tried it. Hopefully this will clear things up for you.

It seems you copied the solution and pasted it into your excel sheet. This contains spaces. Thus you are not finding for "Ball" - you are finding "Ball " (note the space at the end). As this is not what you need Excel ignores the value. To ensure you are looking just for Ball anywhere in the cell, try this:


This way "I have a Ball" , "Balloon" , "FireBall" , and " The Ballroom was big" will all be counted. Dont forget this is NOT case sensitice, so "Handball" will also be counted.

Please let us know how you get on.

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!