Querry Range and Add
 

Hello
My spreadsheet has a variable number of columns from row 19:378. I would
like to search the range for the contents of c384, and whenthe criteria is
met add the cellst he 'found' cell. It doesnt matter whether this is
accomplished by formula or code.
Example:

A19=Cat B19=Cat
A20=10 B20=40

The criteria is Cat found in C384 and the total would be 50 or the total of
all occurences in the range where cat is found.

Im not sure if I have explained adequately or not but I am having a hard
time getting stated on this one.
Thanks!