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.
Does this make sence?
Thanks
iMac, Mac OS X (10.7.3)
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.
Thanks
=SUMIF(A,"Bob",C)
I hope you don't mind me asking you a question based on this answer. What if you want the sum of all the BOB cells and CAROL cells, but not the SANDY cells?
thanks!
Hi kihikihi,
Use addition. Take the formula for Bob, create a formula for Carol and join them with "+".
quinn
Perfect, thanks!
Finding cells in Numbers?
