Results 1 to 3 of 3

Thread: Alternative to standart countifs function needed

  1. #1

    Alternative to standart countifs function needed



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Here is a story... columns A,B,C,D,E is a list,(can be formated as a table) and contain variables in form of numbers.These numbers are from 0 to 37. Need to count how many times each individual number in column E corresponds to the given sett of criteria (columns A,B,C,D). Problem is that l need to account not for individual sets of these criteria, but for groops of them. Groops are to be specified in other worksheet. I can not use ">" , "<" as a criteria argument due to the nature of variables.
    If COUNTIFS function would accept any one of values in specified range of sells as valid criteria, it would look like this
    =countifs('Sheet1'!A:A,A1:A18,'Sheet1'!B:B,B1:B18...)
    Any ideas what could be used?

  2. #2
    Its difficult to imagine what you're trying to do, maybe sample workbook with clear explanation could be help.
    To attach click "Go Advanced" button and find paperclip button to attach your file.

    Thanks

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Hello
    From your explanation, Im afraid I can't understand what you are wanting. I agree with Rizky that we nrrd an example.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •