+ Reply to Thread
Results 1 to 10 of 10

On Google Sheets, can't drag my =countif formula down

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

    Exclamation On Google Sheets, can't drag my =countif formula down

    Hey, me again, unfortunately.

    I am trying to drag my countif formula down so that the C4 cell becomes C5 and it populates itself.

    When I drag it down it says: Error Array arguments to COUNTIFS are of different size.

    Anyone know what I'm getting wrong?


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

    The '18' in the N column is correct. I am trying to drag it to the cell below.

    Appreciate your help!

    Prob.png

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: On Google Sheets, can't drag my =countif formula down

    You could try this one (not tested)

    =countifs('Coupler Pull'!$O2:$O,$C4,'Coupler Pull'!$V$2:$V,">="&M$1,'Coupler Pull'!$V$2:$V,"<="&N$1,'Coupler Pull'!$V$2:$V,"<>")
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

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

    Re: On Google Sheets, can't drag my =countif formula down

    Shouldn't this:

    &N1

    be this:

    &N$1

    Pete

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

    Re: On Google Sheets, can't drag my =countif formula down

    Also, you should mark your previous thread as Solved, as Trevor asked.

    Pete

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

    Re: On Google Sheets, can't drag my =countif formula down

    That hasn't worked unfortunately.. and yes I will do asap!

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

    Re: On Google Sheets, can't drag my =countif formula down

    Thanks. Didn't work unfortunately.

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

    Re: On Google Sheets, can't drag my =countif formula down

    Attach a sample file, rather than a picture of one. The instructions in the yellow banner at the top of the screen explain how you can do this.

    Pete

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: On Google Sheets, can't drag my =countif formula down

    Since you got answers of several forummembers it is good to add to whom you replying.

    I don't have google sheets, but

    "Thanks. Didn't work unfortunately."

    What is the failure you get.

    You will get better help if you add a small file on the forum, so forummember can test the offered solution.

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

    Re: On Google Sheets, can't drag my =countif formula down

    Sorry, I'm at work, hence the speed in which I'm replying. Please forgive me for being impulsive.

    I might be able to add a file later, thanks for the headsup.

  10. #10
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,839

    Re: On Google Sheets, can't drag my =countif formula down

    Your first criteria range isn't anchored properly either:

    =countifs('Coupler Pull'!$O$2:$O,$C4,'Coupler Pull'!$V$2:$V,">="&M$1,'Coupler Pull'!$V$2:$V,"<="&$N$1,'Coupler Pull'!$V$2:$V,"<>")
    Everyone who confuses correlation and causation ends up dead.

+ 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 - Macro to Auto Drag Formulas
    By jharvey87 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 05-21-2022, 12:23 AM
  2. Google Sheets: Get formula to drag down automatically as new data is added
    By woodandrew in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 11-04-2020, 05:46 PM
  3. countif from multiple sheet (In google sheets)
    By wlinksanju in forum Excel General
    Replies: 1
    Last Post: 09-29-2020, 04:24 PM
  4. [SOLVED] Google Sheets - COUNTIF (complex)
    By RLONG98 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 03-19-2020, 01:41 AM
  5. GOOGLE SHEETS: countif with dynamic range
    By Headburst in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 11
    Last Post: 12-30-2019, 09:59 AM
  6. GOOGLE SHEETS: countif with dynamic range
    By Headburst in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-30-2019, 08:41 AM
  7. Converting Unique,Filter,Countif formula in Google Sheets to Excel
    By imnotarobot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-02-2019, 09:51 AM

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