+ Reply to Thread
Results 1 to 2 of 2

sort & report multiple criteria from multiple columns & report back a count to one ce

  1. #1
    Registered User
    Join Date
    10-22-2009
    Location
    Augusta, Maine
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation sort & report multiple criteria from multiple columns & report back a count to one ce

    so for example - column "D" has 582 rows and each cell has 15 different values (1 to 9 and A to F) so i need to select all the instances of say the "C" of the 582 - now the tricky part i need to then have it tell me for all of the "C" values what is the "countif" total in the "M" column for only the "C" values. there are four possible values to count in the "M" column. if needed i can upload a sample of the sheet. also if it is something easy to duplicate for needing it multiple instances (15 of them like 5 times each) selecting the columns and then replacing the criteria would be best. sorry for the lack of terminology. anyone that can help i would appreciate it more than words can even begin to explain. Thank you. Abel.

    PS the entire title did not fit :
    sort and report multiple criteria from multiple columns and report back a count to one cell the # of entries

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: sort & report multiple criteria from multiple columns & report back a count to on

    if needed i can upload a sample of the sheet.
    Yes, please, but make sure it's just enough data to illustrate your problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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