Hey guys,

I am stuck today, I need it done quick and maybe that isn't letting me think clearly....

I have a list of text in column A with their corresponding quantities in column B

EX.

Cat 5
Dog 22
Apple 55
Banana 77

This same list (different qty. results appears in Columns C and D -- then E & F -- Then G & H )

I need to Sum all "Cat" quantities found in all columns --

What would be the most efficient way to do this

thanks

-rt