sum rows that meet a specific criteria

[mase062006]

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

[VBA Noob]

mase062006,

Welcome to the forum

Try

=SUMIF(A:A,"Oranges",B:B)

PS. Please read forum rules below and then use a more descriptive title next time.

VBA Noob