Excel: check text in cell, add values

Closed
Mikaka - Jun 2, 2011 at 03:25 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2011 at 06:48 AM
Hello,

I'm trying to create a formula to check a cell for a certain string of text, and then if it contains it, take the value of a number in that row and and then add them all together.
-
So for example:
-
A1 - A Dog
A2 - The Dog
A3 - A Cat
A4 - A Bird
A5 - The Dog
....
B1 - 10
B2 - 5
B3 - 10
B4 - 10
B5 - 5
...
So I'd like to check the cells in column A, see if it contains the word "dog" and if it does, take the value in column B and sum them all together; so in this case, the subsequent value left in that cell would be 20


Thanks for your help in advanced.



Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 2, 2011 at 05:46 PM
Looks like you would need to use SUMPRODUCT formula
it says there's an answer, but i'm not seeing it
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 3, 2011 at 06:48 AM