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
0
it says there's an answer, but i'm not seeing it
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 3, 2011 at 06:48 AM
0