Combining multiple functions>lookup/sum functions

Someone help me please.
I have attached a table here and i want to come up with a formula that can help me to get a summation of say all floor tiles attributed to Maureen in ctns....
Many Thanks

Mush

Put this code into spreadsheet

Please Login or Register  to view this content.

likewise for betty and Ann

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you.
just to explain a little further, there is a column for floor times and wall tiles. Also, there is there is a column with pcs and ctns. I would appreciate a formula that will help me sum up the total for maureen's floor tiles in ctns and in pcs as well.
Thanks again

Hello!
Try this one: =(COUNTIFS(C:C;"Floor Tiles";I:I;"Maureen")

made a little table which you can add to easily
see attached

Please find attached and see if is what you are looking for.

Best of luck!