+ Reply to Thread
Results 1 to 5 of 5

Sumif Does Not Work in Excel Online

  1. 10-21-2016, 06:27 PM #1
    LeilaGallmeyer
    LeilaGallmeyer is offline
    Registered User
    Join Date
    10-21-2016
    Location
    USA
    MS-Off Ver
    Browser
    Posts
    2

    Sumif Does Not Work in Excel Online

    http://imgur.com/a/ijo8n

    Why oh why won't this work? One error in the image: F1 is supposed to be F:F, but the result is still 0.
    Attached Images Attached Images
    Last edited by LeilaGallmeyer; 10-21-2016 at 06:34 PM. Reason: typo
    Reply With QuoteRegister To Reply
  2. 10-21-2016, 06:28 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Stupid Easy Function in Browser Excel

    Welcome to the board.

    Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 10-21-2016, 06:39 PM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Sumif Does Not Work in Excel Online

    Try changing the date reference to this: " < ="&B2.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 10-21-2016, 06:45 PM #4
    LeilaGallmeyer
    LeilaGallmeyer is offline
    Registered User
    Join Date
    10-21-2016
    Location
    USA
    MS-Off Ver
    Browser
    Posts
    2

    Re: Sumif Does Not Work in Excel Online

    Thank you; that worked. Blamed it on Excel Online, of course, but it had nothing to do with it.
    Reply With QuoteRegister To Reply
  5. 10-21-2016, 06:49 PM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Sumif Does Not Work in Excel Online

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Feel Stupid but here's an easy if/then statment
    By fansoffloyd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2015, 05:16 PM
  2. Easy Question but I feel stupid.
    By Sunday33 in forum Excel General
    Replies: 6
    Last Post: 09-14-2013, 03:58 PM
  3. Easy lookup question - I.R.Stupid
    By BrakZak in forum Excel General
    Replies: 2
    Last Post: 03-06-2007, 05:50 AM
  4. Web hyperlinks: default browser and resulting browser window size?
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 05-18-2006, 11:25 PM
  5. [SOLVED] Am I stupid, or is it Excel???????
    By Confuddled User!!!!!!!!!!!!! in forum Excel General
    Replies: 5
    Last Post: 12-09-2005, 10:30 AM
  6. Stupid, stupid question....
    By DS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2005, 11:05 AM
  7. Excel 2003 worksheet name function?- an easy way to code this
    By eddie_zoom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2005, 07:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1