Excel sum value... [Solved/Closed]

Report
Posts
2
Registration date
Wednesday February 3, 2016
Status
Member
Last seen
February 3, 2016
-
Posts
2
Registration date
Wednesday February 3, 2016
Status
Member
Last seen
February 3, 2016
-
Dear

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

=SUMIF(A:A,"*BALL",B:B)

Please given example through excel.

Thanks

Abdul Nazar

2 replies

Posts
2
Registration date
Wednesday February 3, 2016
Status
Member
Last seen
February 3, 2016
4
Thank you very much, this issue has been solved.

Thanks

Abdul Nazar.
4
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
June 16, 2020
248
Hi Abdul,

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

https://ccm.net/faq/27065-add-values-in-excel-in-columns-that-contain-text

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:

=SUMIF(A:A,"*BALL*",B:B)

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.

I really appreciate thank you messages as a payment for solving issues   :o)