for some reason I am drawing a blank and need to sum rows that meet a specific criteria.


Apples 2
Oranges 2
Bananas 1
Oranges 2

For example, I want a code that will search the columns and sum only the values that correspond to "oranges"

any help would be greatly appreciated.

Thanks in advance