# 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