Excel sum value...
Solved/Closed
anazar
anazar
- Posts
- 2
- Registration date
- Wednesday February 3, 2016
- Status
- Member
- Last seen
- February 3, 2016
anazar
- Posts
- 2
- Registration date
- Wednesday February 3, 2016
- Status
- Member
- Last seen
- February 3, 2016
Related:
- Excel sum value...
- Excel sum of column if another column equals ✓ - Forum - Excel
- Excel sum names - Guide
- Excel sum in french - Guide
- Excel summing up values of scattered data ✓ - Forum - Excel
- Excel Sum Greater than but Less Than ✓ - Forum - Excel
2 replies
anazar
Feb 3, 2016 at 10:58 PM
- Posts
- 2
- Registration date
- Wednesday February 3, 2016
- Status
- Member
- Last seen
- February 3, 2016
Feb 3, 2016 at 10:58 PM
Thank you very much, this issue has been solved.
Thanks
Abdul Nazar.
Thanks
Abdul Nazar.
BrianGreen
Feb 3, 2016 at 01:45 PM
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
Feb 3, 2016 at 01:45 PM
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)
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)