+ Reply to Thread
Results 1 to 4 of 4

Getting Formula Parse Error on Google Spreadsheet

  1. #1
    Registered User
    Join Date
    06-09-2017
    Location
    Reading
    MS-Off Ver
    365
    Posts
    13

    Question 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

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,125

    Re: Getting Formula Parse Error on Google Spreadsheet

    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

  3. #3
    Registered User
    Join Date
    06-09-2017
    Location
    Reading
    MS-Off Ver
    365
    Posts
    13

    Re: Getting Formula Parse Error on Google Spreadsheet

    That's it! Thank you so much!

    Gemma x x

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,125

    Re: Getting Formula Parse Error on Google Spreadsheet

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IMPORTRANGE Formula Parse Error
    By bradfdlad in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-01-2017, 03:33 PM
  2. Parse Google Trends pseudo-API
    By MartinVu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2016, 10:53 AM
  3. [SOLVED] Long IF statement--gives formula parse error
    By turkeyman2000 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-29-2014, 06:34 PM
  4. [SOLVED] Parse Error - Google Drive Spreadsheet
    By mglassco in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-22-2013, 03:51 PM
  5. Replies: 0
    Last Post: 02-25-2012, 10:54 PM
  6. Parse Google calendar for addresses in appointments
    By sellenwood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2011, 03:50 AM
  7. Parse a Spreadsheet
    By leebre in forum Excel General
    Replies: 1
    Last Post: 08-09-2007, 05:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1