I have a list of names in different cells in numbers and I want to identify certain names with totals in them. How can i do that? Like the cells might have names like bob in one carol in one sandy in one and I want to find all of the Bob cells.
What do you mean by "find"? Do you want to count them up? Do you want to sum up some other numbers associated with those names? Do you want to sort them to the top? Do you want to lookup all rows that have "bob" and list them all in another table?
I do want to sum up the cells. The cells that I want to do it with are mixed in the list of other cells. Column a has the different names in each cell. Column c has the dollar amount. I want to be able to sum all of a certain name in column a.