Try
=SUMIFS('EMEA programs'!$P$2:$P$1000,'EMEA programs'!$AB$2:$AB$1000,$D$17,'EMEA programs'!$E$2:$E$1000,$A$18,'EMEA programs'!$C$2:$C$1000,$B$16,'EMEA programs'!$A$2:$A$1000,$A$17)
Sheet names must be in single quotes (') as they contain a blank
Bookmarks