Helping extract data from Lists

Hi,

I have an array of data like this

Company Lead Area Value
A John ghij 3453
B James klm 345
B Matthew nop 452345
C Mark qrs 345
E Luke tuv 345
D Tom wxt 345

I want to extract the data so that when the Company column = B then I can move along and extract the correspondng value from the value column and the values.

For example I would look for company B and get the value out of 345+452345 = Whatever.

Then Company C I would get the value 345.

I need it to work so that I can change the company name in the Company column and it will still search the Value column and add all values that correspond to the company.

Hope that explains it!!!

Cheers.

Try Sumif()

=Sumif(B:B,X1,C:C)

where X1 contains your company selection and B:C are the column to search and sum.