Creating a string with all cells that meet criteria for SUMIF formula
Posted on 2011-03-02
I've got a SUMIF formula I'm using to search a table and sum any line items which have a certain value in Column A.
ColA: Type ColB: Name ColC: Cost
Child John1 $100
Adult John2 $200
Child John3 $150
Adult Jane4 $300
Child Jane5 $75
Child Jane6 $50
So, SUMIF (A:A, "Child", C:C)= $375
What command / formula can I use now to create a list of all the names associated with that summation in a cell as a string? In the above example, I want to know that the cost of "$375" is associate with "John1, John3, Jane5, Jane6, "