Getting Formula Parse Error on Google Spreadsheet

Hi
Is anyone able to see anything wrong with the syntax in my formula, or suggest pitfalls which might be tripping it up?

=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)

Unfortunately the actual Google sheet is on a secure company site, so I can't share the actual document. It's a budget tracker and the reference to Col P is summing the Dollar value.....then I'm trying to reference 'Status' (Col AB) with a common value on my summary sheet, 'Type' (Col E) with a common value on my summary sheet, 'Quarter' (Col C) with a common value on my summary sheet and lastly 'Region' (Col A) with a common value on my summary sheet. I had this working on a test file that I built, but for the life of me cannot see why this isn't working.
I have used Data Validation to lock down the values to be selected on my 'real' document, whereas I hadn't on my test, but I can't imagine that this would negatively affect the formula.

Thanks
Gemma
x

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

That's it! Thank you so much!

Gemma x x

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.