Results 1 to 2 of 2

Help with max counts of numbers in multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    05-22-2019
    Location
    West Palm Beach
    MS-Off Ver
    MS office
    Posts
    7

    Help with max counts of numbers in multiple columns

    I am trying to get a max count of multiple columns (C,D,E) on the attached. Currently the formula I have(=MAX(COUNTIFS(Assessment!$A$3:$A$97,J9,Assessment!$C$3:$C$97,">0"),COUNTIFS(Assessment!$A$3:$A$97,J9,Assessment!$D$3:$D$97,">0"),COUNTIFS(Assessment!$A$3:$A$97,J9,Assessment!$E$3:$E$97,">0"))) is giving me 9 counts which is not accurate since the count on the attached should be 10. Thanks for your help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with max counts of numbers in multiple columns
    By cshrestha in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 08-19-2019, 04:29 PM
  2. Identification of duplicate numbers and missing numbers in multiple columns
    By kswapnadevi in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-18-2018, 11:50 AM
  3. Filtering and Total counts of duplicates from multiple columns
    By kor123 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-23-2016, 11:55 PM
  4. Replies: 3
    Last Post: 07-28-2014, 03:48 AM
  5. Table/function that counts number of occurrences within multiple columns
    By Superion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2013, 06:38 PM
  6. [SOLVED] Multiple unique counts depending on other columns
    By gerainta in forum Excel General
    Replies: 2
    Last Post: 07-27-2012, 09:33 AM
  7. counts of numbers (or letters) in columns
    By molemeister in forum Excel General
    Replies: 1
    Last Post: 06-07-2010, 03:55 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