organizing rows and columns by text
 

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?

organizing rows and columns by text
 

"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?