+ Reply to Thread
Results 1 to 3 of 3

Problem with a SUMIFS formula

  1. #1
    Registered User
    Join Date
    01-24-2019
    Location
    London, England
    MS-Off Ver
    365
    Posts
    18

    Problem with a SUMIFS formula

    Hi everyone

    I wonder if you could please help me with the correct syntax for a SUMIFS formula? I've tried everything (although clearly not!) to get this to work, but I'm having no luck.

    Here's what I'm trying to achieve:

    SUM the total of column L if the contents of column M on a tab called _oneoff is London and the contents of F on the same tab is Annual

    Here's my current formula which gives me the error "The syntax of this name isn't correct":

    =SUMIFS(_oneoff!L:L,_oneoff!M:M,"London",[_oneoff!F:F,"Annual"])

    Many thanks,
    Jon

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,035

    Re: Problem with a SUMIFS formula

    =SUMIFS(_oneoff!L:L,_oneoff!M:M,"London",[_oneoff!F:F,"Annual"])
    Remove the red maked brackets. and you may need to add single quotes before and after sheet name.
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    01-24-2019
    Location
    London, England
    MS-Off Ver
    365
    Posts
    18

    Re: Problem with a SUMIFS formula

    Excellent, Thank you so much, Paul.

+ 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] Problem with SUMIFS formula
    By AlexnL12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-26-2018, 03:36 AM
  2. Problem with SUMIFS by Month Formula
    By thetribal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2017, 12:50 AM
  3. [SOLVED] Problem with sumifs formula
    By TUKARAM_45471 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2017, 04:52 AM
  4. [SOLVED] Problem with SUMIFS (or am I using the wrong formula???)
    By stubbsj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2015, 08:42 AM
  5. [SOLVED] SUMIFS Formula Problem
    By AlexMillington in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-28-2014, 01:54 PM
  6. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  7. sumifs (i think) formula problem
    By big_nath in forum Excel General
    Replies: 2
    Last Post: 09-30-2011, 09:58 AM

Tags for this Thread

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