Explain Function problem

Hi all,

I would really appreciate some help with this - it’s a real pain !!!

I have a column of text and a column of numbers as shown bellow

A B

a 2
b 3
c 2
b 3

I would like to write a function that will look at the text and if it is equal to "a" or "b" then add the value from the B column to a cell on sheet two.
In the example above I would have a Cell on sheet2 that would have 8 in it

Hope my explanation makes sense !

Thanks in advance for your help
Martin

use:
=SUMIF(A1:A4,"a",B1:B4)+SUMIF(A1:A4,"b",B1:B4)

your data lies in the range A1:B4

Mangesh

Hi,

Thats Perfect

Thanks Loads
Martin