+ Reply to Thread
Results 1 to 4 of 4

COUNTIFS error

  1. #1
    Registered User
    Join Date
    02-07-2022
    Location
    London, England
    MS-Off Ver
    Professional: 2021
    Posts
    8

    Question COUNTIFS error

    Hi all,

    I was just wondering if anyone could spot what is wrong with this formula:
    =COUNTIFS('All households'!$V$2:$V$5263,"Successful",'All households'!$C$2:$D$5263,"Rural")

    I keep getting the #VALUE! error.

    Thanks beforehand.
    Attached Files Attached Files
    Last edited by undergrad08; 02-08-2022 at 02:27 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: COUNTIFS error

    From the help file for the COUNTIFS() function
    Quote Originally Posted by MS Excel Help
    Important: Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other.
    https://support.microsoft.com/en-us/...rs=en-us&ad=us
    Note that range two is 5262 rows by 2 columns (C2:D5263) where range 1 is 5262 rows by 1 column (V2:V5263). I expect that you intended range two to only be looking at column C, and expect you will get the correct result if you make that edit to the formula.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: COUNTIFS error

    It is because your second range is two columns wide, whereas your first range is only one column. What exactly are you trying to achieve?

    Pete

  4. #4
    Registered User
    Join Date
    02-07-2022
    Location
    London, England
    MS-Off Ver
    Professional: 2021
    Posts
    8

    Re: COUNTIFS error

    Thanks!!
    Can't believe I didn't see that

+ 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. Compile Error - Syntax Error using CountIfs in VBA
    By ByTheLake in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2019, 12:47 PM
  2. [SOLVED] COUNTIFS error
    By Celex005 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2014, 03:28 PM
  3. COUNTIFS #name error
    By qwertyjjj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-27-2014, 05:34 PM
  4. COUNTIFS Error
    By whizbee in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 07-19-2013, 04:33 PM
  5. COUNTIFS Error
    By mgsc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 10:01 AM
  6. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  7. Error using countifs
    By welchs101 in forum Excel General
    Replies: 6
    Last Post: 11-08-2011, 08:20 AM

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