Formula Help Needed

[pdetter]

Hello Excel Gurus,

I am having some difficulty and looking for some help. I am trying to pull together an expense report from several different locations. Unfortunately not all of the locations have the same accounts or are in the same order. I have compiled a list of the accounts on sheet 1 but now am having issues in trying to create a formula that will look at what I have in A1 on Sheet 1, and compare that to what I have in Sheets 2,3 and 4 and if there is a match pull in and sum those numbers for those months.

A B C
[TABLE="width: 357"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD][/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]Feb-18[/TD]
[/TR]
[TR]
[TD]Total Expenses[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500185 - Interior Paint[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500225 - Landscaping[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500140 - Gas & Electric[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500210 - Janitotial CAM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sheet 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Expenses[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500225 - Landscaping[/TD]
[TD][/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]350[/TD]
[/TR]
[TR]
[TD]500140 - Gas & Electric[/TD]
[TD][/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sheet 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Expenses[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500185 - Interior Paint[/TD]
[TD][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]500140 - Gas & Electric[/TD]
[TD][/TD]
[TD="align: right"]350[/TD]
[TD="align: right"]375[/TD]
[/TR]
[TR]
[TD]500210 - Janitotial CAM[/TD]
[TD][/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]125[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sheet 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Expenses[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500225 - Landscaping[/TD]
[TD][/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]500210 - Janitotial CAM[/TD]
[TD][/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]150[/TD]
[/TR]
</tbody>[/TABLE]


So in Sheet 1 I'm having trouble getting the formula right to find and then sum up the information in Sheets 2,3,4.

Thanks for the help.

 

[Special-K99]

Use

SUMIF(Sheet2...)+SUMIF(Sheet3....)+SUMIF(Sheet4...)