Vlookup & Sumif?

[Alagan]

Hi people,

OK here goes.

I have data in sheet 1:

Company 1(column A) 2000(Column B)
Company 2(column A) 3000(column B)
Company 1("") 2000("")
Company x x amount of currency

So what would I like to do?

On sheet 2 I have company 1, and would like to sum column B but not limited to column B.

I know of SUMIF(blah blah blah)

But i would like to incorporate a sumif and vlookup together to enable multiple column referencing!

Any ideas?

Anticipated response on this would be HUGELY APPRECIATED!!

 

[Peter_SSs]

Alagan

I am not really clear on exactly what you want. Can you give a more clear set of sample data and the expected results for that sample? Maybe post a screentshot to make it clearer? Here's how:

Colo's HTML Maker
or
Excel jeanie