=sumif between two files

**Christopherdj** · 03-25-2013, 09:15 PM

The attached sheets require an =sumproduct (I think) to look up data and combine all instances of the totals from the CM Original Budget vs Actual 2013 file commencing from column AA and placing in the corresponding cells in the Division Updates budget vs Actual.

I have used a raw = format however that will not pick up any additional lines added into the datafile when/if they are added, so I'm hoping a sumproduct will work.

thanks in anticipation.

**rylo** · 03-25-2013, 09:27 PM

Hi

Sumproduct really requires you to have a range that isn't an entire column so try using sumif instead.

=SUMIF('[CM Original Budget vs Actual 2013.xls(1).xlsx]NCDEA ALL Division Report'!$B:$B,A15,'[CM Original Budget vs Actual 2013.xls(1).xlsx]NCDEA ALL Division Report'!$AA:$AA)

rylo