Summing using VLOOKUP
 

I have various line items and a few totals (that are capitalized) below
the items. The data is in various tabs. I want to total the Capitalized
items only. It would be great if someone could help.

Thanks.

p.s. the data is in this form:
A B
52000-0001 Salaries-general 1,212,122
52000-0002 Salaries-overtime 5,650
52050-0000 Student help -1,932
52060-0000 Temp help 13,046
52900-0000 Reserve-micp -138,458
TOTAL SALARIES 1,004,723

The above data is replicated across various tabs. I just want a total
of the TOTAL SALARIES, in a new Totals tab.

Summing using VLOOKUP
 

=SUMPRODUCT(SUMIF(INDIRECT("'"&C1:C3&"'!a2:a20"),
"*TOTAL*",(INDIRECT("'"&C1:C3&"'!b2:b20"))))

where C1:C3 is a range housing the relevant sheetnames in
separate cells.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"rusty24" wrote in message
oups.com...
I have various line items and a few totals (that are capitalized) below
the items. The data is in various tabs. I want to total the Capitalized
items only. It would be great if someone could help.

Thanks.

p.s. the data is in this form:
A B
52000-0001 Salaries-general 1,212,122
52000-0002 Salaries-overtime 5,650
52050-0000 Student help -1,932
52060-0000 Temp help 13,046
52900-0000 Reserve-micp -138,458
TOTAL SALARIES 1,004,723

The above data is replicated across various tabs. I just want a total
of the TOTAL SALARIES, in a new Totals tab.

Summing using VLOOKUP
 

Bob,

I am not able to get the desired output. The TOTAL SALARIES line item
has just the hard coded totals, and not all the capitalized items are
sums, e.g. EBIT which is EBITDA less Depreciation. I suppose I will
have to use VLOOKUP. I was just wondering if I can total the VLOOKUP
results that I get across various tabs, by writing just one formula.

Thanks,