+ Reply to Thread
Results 1 to 5 of 5

Countifs for more than one column

  1. #1
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    402

    Countifs for more than one column

    Hello,

    The following formula works for counting data in 'Survey Data'!A:A

    =COUNTIFS('Survey Data'!A:A,Appraisal!A3,'Survey Data'!K:K,">="&B1,'Survey Data'!K:K,"<="&C1)

    How can I adjust to also count (sum) matching data Columns B & C also.

    I tried this first but it didn't work:

    =COUNTIFS('Survey Data'!A:C,Appraisal!A3,'Survey Data'!K:K,">="&B1,'Survey Data'!K:K,"<="&C1)

    I appreciate any help.

    Thank you,

  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
    44,425

    Re: Countifs for more than one column

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    402

    Re: Countifs for more than one column

    Update, I had to use Sumproduct

    =SUMPRODUCT(('Survey Data'!$A$2:$C$500000=Appraisal!A3)*('Survey Data'!$K$2:$K$500000>=$B$1)*('Survey Data'!$K$2:$K$500000<=$C$1))

  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
    44,425

    Re: Countifs for more than one column

    Thanks for sharing your solution.

  5. #5
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,408

    Re: Countifs for more than one column

    Pls try this formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by wk9128; 05-26-2022 at 08:10 PM.

+ 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. [SOLVED] Countifs With Yes In Column C
    By BobBrown60 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-22-2020, 06:06 PM
  2. AVERAGEIFS AGE & COUNTIFS Column C contains Y OR column D contains Y
    By Jatzbiscuits in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-10-2020, 01:44 AM
  3. COUNTIFS( where one criteria compares a column to another column)
    By corecomps in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-26-2019, 02:02 PM
  4. Countifs - date column by month & second column text value
    By Chelrie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2016, 04:33 PM
  5. [SOLVED] CountIfs any value in a column starts with the value in another column
    By heresteve2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-24-2016, 04:14 PM
  6. multiply countifs by value in different column of same row
    By jben86 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-06-2013, 10:08 PM
  7. Replies: 0
    Last Post: 12-16-2011, 09:01 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