+ Reply to Thread
Results 1 to 5 of 5

Countifs formula not working

  1. #1
    Forum Contributor
    Join Date
    03-17-2013
    Location
    London, England
    MS-Off Ver
    Microsoft 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit
    Posts
    150

    Countifs formula not working

    Hi all,

    =COUNTIFS(B17:BN23,"H",B24:AF28,"H",AJ24:AU24,"H")

    For some reason I get the #value error when doing the above formula and cannot think why?

    Any ideas? Sorry I could not post a test spreadsheet as I am posting this from my mobile phone.

    Thanks in advance

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Countifs formula not working

    The ranges in the formula aren't the same size.
    Last edited by Norie; 11-10-2016 at 06:58 AM.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Countifs formula not working

    All the ranges must be the same dimensions.

    Yours are all different.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Forum Contributor
    Join Date
    03-17-2013
    Location
    London, England
    MS-Off Ver
    Microsoft 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit
    Posts
    150

    Re: Countifs formula not working

    Ah I see, to count the amount of H in those cells would I require another formula all together? Any idea what I could use?

    Thanks for your helps so far

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Countifs formula not working

    =COUNTIF(B17:BN23,"H")+COUNTIF(B24:AF28,"H")+COUNTIF(AJ24:AU24,"H")

    might be one way. Unless I'm misinterpreting your needs.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. COUNTIFS formula not working to make this report
    By Sanjibghosh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2016, 01:58 AM
  2. Need help with formula Countifs and Vlookup not working
    By Iwant2learnmore in forum Excel General
    Replies: 1
    Last Post: 08-25-2015, 12:49 AM
  3. [SOLVED] Countifs formula not working when referenced to another worksheet
    By Burt_100 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-18-2014, 06:11 PM
  4. [SOLVED] Countifs and concatenate formula not working
    By ensmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2014, 03:50 PM
  5. Formula half working. IF( Countifs)
    By Unnefable in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-01-2013, 12:11 PM
  6. Countifs FOrmula Not working
    By cartica in forum Excel General
    Replies: 1
    Last Post: 10-30-2013, 01:34 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

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