+ Reply to Thread
Results 1 to 11 of 11

Keep getting my formula is missing parenthesis

  1. #1
    Registered User
    Join Date
    07-08-2020
    Location
    Birmingham
    MS-Off Ver
    Office 97
    Posts
    7

    Keep getting my formula is missing parenthesis

    I have the below formula and i keep getting the error missing parenthesis

    can anyone help?

    =+IF(MATCH($C40='EDGE Data'!$P2:$P5000,'EDGE Data'!P2:P5000 ,0, SUMIF('EDGE Data'!$V$2:$V$5000,2,'Edited Data'!$E$2:$E$5000)

    thank you for the help in advance

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    54,936

    Re: Keep getting my formula is missing parenthesis

    Welcome to the forum.

    What are you trying to do with this formula? It is completely incorrect. Please explain in WORDS.

    Are you REALLY still on Office 97?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    07-08-2020
    Location
    Birmingham
    MS-Off Ver
    Office 97
    Posts
    7

    Re: Keep getting my formula is missing parenthesis

    i have 3 columns

    Values Totals Key
    oh132 26.5 1
    oh3254 26.5 1
    oh34534 22.5 2
    oh2523 21.5 3

    i am trying to produce a formula that will add up the totals of each key if i enter an exact match to the values in a cell

    So if i typre the value oh132 it will add the totals on anything that has a number 1 in the key

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    54,936

    Re: Keep getting my formula is missing parenthesis

    I think you need SUMIFS, but I need to know which version of Excel you are using, please.

    There are instructions at the top of the page explaining how to attach your sample workbook.

  5. #5
    Registered User
    Join Date
    07-08-2020
    Location
    Birmingham
    MS-Off Ver
    Office 97
    Posts
    7

    Re: Keep getting my formula is missing parenthesis

    Keep getting a message that the file size is too large

  6. #6
    Registered User
    Join Date
    07-08-2020
    Location
    Birmingham
    MS-Off Ver
    Office 97
    Posts
    7

    Re: Keep getting my formula is missing parenthesis

    please see file attached
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-08-2020
    Location
    Birmingham
    MS-Off Ver
    Office 97
    Posts
    7

    Re: Keep getting my formula is missing parenthesis

    what i am trying to do is match invoice numbers in the Data tab against whatever is typed into the invoice column in the recon tab

    the formula needs to match the number then check the day is correct then total up anything in the paid column and add it to Mondays column these steps would then be repeated for Tuesdays and so on

  8. #8
    Registered User
    Join Date
    07-08-2020
    Location
    Birmingham
    MS-Off Ver
    Office 97
    Posts
    7

    Re: Keep getting my formula is missing parenthesis

    i have attached an example sheet to better explain what it is i am trying to do

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    54,936

    Re: Keep getting my formula is missing parenthesis

    You still haven't said which version of Excel you are using. Please tell us.

  10. #10
    Registered User
    Join Date
    07-08-2020
    Location
    Birmingham
    MS-Off Ver
    Office 97
    Posts
    7

    Re: Keep getting my formula is missing parenthesis

    Cant find the face palm..damit.

    Iv broken away for the weekend now so cant check but im pretty sure its office 97

  11. #11
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    13,273

    Re: Keep getting my formula is missing parenthesis

    I don't see any columns labeled Values, Totals or Key nor do I see any entries that look like oh132 in the file attached to post #6.
    I am pretty sure you are not using Excel 97 as the .xlsx file format was introduced with the 2007 version (prior to that Excel used the .xls file format).
    As for the formula, I feel that it could read (as Ali suggests):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    As there is nothing in columns P nor V of the EDGE Data sheet I can not test. It would also be helpful to see at least one manually calculated result with which to compare the result of the formula.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Formula is missing an opening and closing parenthesis
    By mq1973 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-24-2019, 10:28 AM
  2. [SOLVED] Can't see missing parenthesis in conditional format formula
    By Ochimus in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-28-2017, 02:42 PM
  3. Replies: 1
    Last Post: 04-10-2016, 11:42 AM
  4. Replies: 5
    Last Post: 09-01-2015, 09:06 PM
  5. [SOLVED] Missing parenthesis or too many argument on a formula
    By dache416 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2014, 01:15 PM
  6. [SOLVED] IF statement missing parenthesis in formula
    By Abyrose in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2014, 06:24 PM
  7. [SOLVED] Formula missing parenthesis
    By katieshields in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2014, 03:44 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