Using SUM & VLOOKUP together??
 

Can anyone tell me what's wrong with these formulas? Using small test
workbook.


=SUM(VLOOKUP(A7,Sheet2:Sheet3!A1:D5,2,FALSE)) This gives #VALUE!

I have a top worksheet which sums the values of several other worksheets
which are "almost" identical. Worksheets 2+ have identical columns, but
only some of the rows.
The first column represents the same unique data in all worksheets. (Item#)

How can I display the total(s) on sheet1 of all the identical items on all
other sheets?
Keep in mind that each item may not appear on all sheets and it may be on a
different line# on various sheets.

Help!

Using SUM & VLOOKUP together??
 

=SUM(VLOOKUP(A7,Sheet2:Sheet3!A1:D5,2,FALSE))
This gives #VALUE!

You can't use VLOOKUP across multiple sheets like that.

Try this:

=SUMIF(Sheet2!A1:A5,A7,Sheet2!B1:B5)+SUMIF(Sheet3! A1:A5,A7,Sheet3!B1:B5)

--
Biff
Microsoft Excel MVP


"Steven" wrote in message
...
Can anyone tell me what's wrong with these formulas? Using small test
workbook.


=SUM(VLOOKUP(A7,Sheet2:Sheet3!A1:D5,2,FALSE)) This gives #VALUE!

I have a top worksheet which sums the values of several other worksheets
which are "almost" identical. Worksheets 2+ have identical columns, but
only some of the rows.
The first column represents the same unique data in all worksheets.
(Item#)

How can I display the total(s) on sheet1 of all the identical items on all
other sheets?
Keep in mind that each item may not appear on all sheets and it may be on
a different line# on various sheets.

Help!