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
Bookmarks