+ Reply to Thread
Results 1 to 3 of 3

Google Sheets: Sumif returns 0?

  1. #1
    Registered User
    Join Date
    03-23-2021
    Location
    euxton, england
    MS-Off Ver
    excel windows 10
    Posts
    1

    Google Sheets: Sumif returns 0?

    Hi, I am having a bit of trouble getting a sumif formula to work and i cant understand why, im not the best with spreadsheets and generally just google problems to find formulas for different things, im wondering if anyone might be able to help me with this as i just cant understand why it keeps returning 0 for me?

    I have Column E with a range of dates and column R with amounts, and i want the forumla to add up any amounts in column R that have the same date in column E as what i have in my column Y.

    my formula is =SUMIF(E5:E76,"*"&Y5&"*",R5:R76) to my understanding this formula should add up any amounts in column R where the date in column E is the same as what is in cell Y5?

    i created a google sheet with it in but as i am new to this forum it wont let me post the link.


    Thanks, Tom.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Google Sheets: Sumif returns 0?

    Maybe try just
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-28-2021
    Location
    Minneapolis, MN
    MS-Off Ver
    2019
    Posts
    7

    Re: Google Sheets: Sumif returns 0?

    I am having the same problem.

+ 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] Google Sheets: COUNTIFS and SUMIF formulas returning 0
    By algoit in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 01-23-2021, 03:28 AM
  2. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  3. Google sheets: multiple returns of frequent text
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-08-2020, 07:59 PM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. [Google Sheets ] Using ImportXML returns a wrong value
    By Kimberley in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 11-07-2017, 02:10 PM
  6. Replies: 2
    Last Post: 06-21-2017, 06:32 PM
  7. SUMIF with different date formats (Google Sheets)
    By djarcadian in forum Excel General
    Replies: 1
    Last Post: 08-09-2014, 08:16 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1