+ Reply to Thread
Results 1 to 5 of 5

Sumif Does Not Work in Excel Online

Hybrid View

  1. #1
    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

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    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

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,933

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    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.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,933

    Re: Sumif Does Not Work in Excel Online

    You're welcome!

+ 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. 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 gjh3124@yahoo.com.au 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. [SOLVED] Stupid, stupid question....
    By DS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2005, 11:05 AM
  7. [SOLVED] 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1