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!!
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!!