Help with SUMIFS – excel 2007

Hi,

 

This is my formula its currently pulling volume information by period from a workbook into this workbook, I need add another level to say just bring just a certain section (thats in column A) in the Destination workbook, from D in the Source workbook. Any ideas how I do it? 

 

=SUMIFS(‘C:MDEMMAGroupsbedfordBedford Planning18-19 Planning[Bedford – New Annual Plan – In Progress.xlsx]1819’!$AR$2:$AR$4500, ‘C:MDEMMAGroupsbedfordBedford Planning18-19 Planning[Bedford – New Annual Plan – In Progress.xlsx]1819’!$AN$2:$AN$4500,$C3, ‘C:MDEMMAGroupsbedfordBedford Planning18-19 Planning[Bedford – New Annual Plan – In Progress.xlsx]1819’!$AL$2:$AL$4500,H$2, ‘C:MDEMMAGroupsbedfordBedford Planning18-19 Planning[Bedford – New Annual Plan – In Progress.xlsx]1819’!$AX$2:$AX$4500,””)

+SUMIFS(‘C:MDEMMAGroupsbedfordBedford Planning18-19 Planning[Bedford – New Annual Plan – In Progress.xlsx]1819’!$AW$2:$AW$4500, ‘C:MDEMMAGroupsbedfordBedford Planning18-19 Planning[Bedford – New Annual Plan – In Progress.xlsx]1819’!$AS$2:$AS$4500,$C3, ‘C:MDEMMAGroupsbedfordBedford Planning18-19 Planning[Bedford – New Annual Plan – In Progress.xlsx]1819’!$AL$2:$AL$4500,H$2, ‘C:MDEMMAGroupsbedfordBedford Planning18-19 Planning[Bedford – New Annual Plan – In Progress.xlsx]1819’!$AX$2:$AX$4500,””)

 

Volumes 1 = Ar

Workdescription 1 = An

period = AL

 

Volumes 2 = Aw

Workdescription 2 = As

Period = AL

 

$C4 – lookup value job description

H – Lookup value – period

 

CRITICAL ASSET WORK = AX

By: Leanne Hollins

Leave a Reply

Your email address will not be published. Required fields are marked *