Results 1 to 13 of 13

The Formula you typed contains an error

Threaded View

  1. 05-07-2017, 09:26 AM #1
    Patcheen
    Patcheen is offline
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    The Formula you typed contains an error

    =SUMIF(F7:F44=A62,IF(G7:G44="won"*3),IF(G7:G44="Drew"*1)

    f7:f44 is teams that has to match a62

    g7:g44 is won, drew, lost if won 3 points and if drew 1 point

    the formula above isnt working as when i input it it says "The Formula you typed contains an error" but i cant see where
    Last edited by Patcheen; 05-07-2017 at 09:32 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Subroutine help required - 'The formula you typed contains an error'
    By AuntyJean in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-23-2015, 02:41 PM
  2. [SOLVED] Inputbox error message. Formula you typed contains an error.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2013, 02:25 PM
  3. Error in formula - "Formula typed contains error"
    By mstevenson in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 11-27-2012, 01:15 PM
  4. The Formula You Typed Contains An Error
    By Strill in forum Excel General
    Replies: 2
    Last Post: 04-21-2011, 08:38 PM
  5. formula typed contains an error
    By associates in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2006, 12:50 PM
  6. [SOLVED] Formula you typed contains an ERROR message - HELP
    By NS in forum Excel General
    Replies: 5
    Last Post: 08-16-2005, 12:05 PM
  7. How to make error handle for mis-typed variable?
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-01-2005, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1