+ Reply to Thread
Results 1 to 6 of 6

On Google Sheets trying to =Countifs a cell as criteria, not a value.

  1. #1
    Registered User
    Join Date
    05-25-2022
    Location
    London
    MS-Off Ver
    Google Sheets
    Posts
    16

    Exclamation On Google Sheets trying to =Countifs a cell as criteria, not a value.

    =countifs('Pull'!$O2:$O,"Outbound",'Pull'!$V$2:$V,">="&M$1,'Pull'!$V$2:$V,"<="&N1,'Pull'!$V$2:$V,"<>")

    This is my formula. I want to count the cell that the text "outbound" is in, not the word 'outbound' but whenever I remove the "outbound" in the formula and replace it with "C4" which is the cell number/location, it thinks I mean the letter word value "C4". Any help here?

    Whenever I go online it just tells me to type in the location, but it doesn't let me!

    Really appreciate some help - many thanks.

    Forum ask.png

  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
    36,796

    Re: On Google Sheets trying to =Countifs a cell as criteria, not a value.

    Don't put C4 in quotes. So, NOT "C4", just C4.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,776

    Re: On Google Sheets trying to =Countifs a cell as criteria, not a value.

    You may need to surround "outbound" by wildcard characters if you want to include cells which contain that word among others (as your picture shows).

    Hope this helps.

    Pete

  4. #4
    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
    36,796

    Re: On Google Sheets trying to =Countifs a cell as criteria, not a value.

    @Pete: I don't think there is anything else in cell C4, though not easy to tell from the picture.

  5. #5
    Registered User
    Join Date
    05-25-2022
    Location
    London
    MS-Off Ver
    Google Sheets
    Posts
    16

    Re: On Google Sheets trying to =Countifs a cell as criteria, not a value.

    Yeah you were right it was just C4! Thanks!

  6. #6
    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
    36,796

    Re: On Google Sheets trying to =Countifs a cell as criteria, not a value.

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Google Sheets: How to combine CountIfs and an array formula
    By e-ads in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 05-20-2022, 03:47 PM
  2. Countifs not working in Google Sheets
    By acruthi in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 12-02-2021, 12:11 AM
  3. [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
  4. 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
  5. 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
  6. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 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