I am trying to add up values in cells that correspond to text in other cells.
So, let's say I have 100 rows of various text and columns next to each of
those rows have various values. I then want to select certain rows of text
based on a certain word in that cell, and if possible, add up the values in
other columns for that row. For instance, say I want to organize all rows in
column A that have the word cat in it. One row might have "Fat Cat", another
might have "Cat food", another might have "Cat types", etc, etc. I want to
take all cells in that column A that have the word cat in it and organize
them in a group so I can then take numbers from cells corresponding to that
row but in different columns and add them up. Or I can just group all rows
together with "cat" in them and then add the columns. Any ideas on this?

"cat" text being in column A, numbers in column B:

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

--
Regards!
Stefi



€žMike€� ezt Ã*rta:

I am trying to add up values in cells that correspond to text in other cells.
So, let's say I have 100 rows of various text and columns next to each of
those rows have various values. I then want to select certain rows of text
based on a certain word in that cell, and if possible, add up the values in
other columns for that row. For instance, say I want to organize all rows in
column A that have the word cat in it. One row might have "Fat Cat", another
might have "Cat food", another might have "Cat types", etc, etc. I want to
take all cells in that column A that have the word cat in it and organize
them in a group so I can then take numbers from cells corresponding to that
row but in different columns and add them up. Or I can just group all rows
together with "cat" in them and then add the columns. Any ideas on this?