Creating formula for If [This happen] and if true, insert (Adult) if False, (Baby)

I have a table like so...[table="width: 500"]

Family Name	Quantity	Sizes	Category	Total Shirts	Total Price	Payment Type
(Example)Johnson	3	XX-Large	Adult	6	$60.00	Credit
(Example)Johnson	3	Small	Adult	Null	Null	Null
Jackie	3	Medium	...	...	...	...

** I have another table that indicates different sizes and also it has like adult and baby like example below

Adult	Baby
Small	2 Months
Medium	4 Months
XX-Large	12 Months

I am trying to get a formula for Category,Total Shirts, and Total Price

For Category Cell - If C2(1st chart) Contains any Adult Size, category should say "Adult", But if it doesn't contain the Adult Size category should say "Baby".

For Total Shirts Cell - I need this cell to combine all the "Similar Names in Cell A" and Calculate how many shirts that group has.

For Total Price Cell - Combine all the "similar names in Cell A" and add a total price (For every one shirt they are $10) So 1=$10

A Example Is given Above how i want the format to look

Thank You So Much.. If You need more understand Please Reply, Email me, Or do whatever you have to do thanks So Much Again

Lamar