Closed Thread
Results 1 to 3 of 3

Countifs not working in Google Sheets

  1. 11-30-2021, 02:55 PM #1
    acruthi
    acruthi is offline
    Registered User
    Join Date
    05-20-2015
    Location
    washington
    MS-Off Ver
    2010
    Posts
    19

    Countifs not working in Google Sheets

    Hi All,

    I am trying to get countifs to work with multiple filters on location and termination dates but it's giving me incorrect values. Can someone please help!

    I tried countA with filter on Row 17 but that does not work either.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-01-2021, 09:29 AM #2
    Flyboy65
    Flyboy65 is offline
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Countifs not working in Google Sheets

    Hi acruthi,

    The formula you are using is a bit confusing. Could you explain exactly what you are trying to achieve and what your expected results would be.
    Reply With QuoteRegister To Reply
  3. 12-02-2021, 12:11 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Countifs not working in Google Sheets

    This has been posted in the CS forum, so I am closing this thread now.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
Closed 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. [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. Google Sheets: countifs multiple criteria from multiple sheets
    By wlinksanju in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 10
    Last Post: 06-16-2020, 11:23 PM
  3. [SOLVED] Google Sheets: IMPORTRANGE/TRANSPOSE NOT WORKING
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-17-2018, 12:36 PM
  4. Array formula not working in Google Sheets
    By nappy1001 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-20-2018, 12:14 PM
  5. Google Sheets Script not working
    By jsmity in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-02-2017, 11:36 AM
  6. From Excel working to Google Sheets no longer working
    By rad1964 in forum Excel General
    Replies: 5
    Last Post: 07-19-2016, 10:23 PM
  7. [SOLVED] countifs working on extended ranges and different sheets not working
    By etaf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2013, 02:23 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