I want to use something like COUNTIF, but I need to be able to check 2 non-consecutive columns for specific values. For instance, I need to check a range of cells in column A for the value 20 and column F for the value 10. When both are true, then count it. I am thinking there is a way to use an Array Function along with a “double” COUNTIF. I just can’t figure it out. Any ideas?

    Viewing 0 reply threads
    • #1775151

      Try this:


      This is an array formula and must be entered using Control+Shift+Enter

      • #1775234

        Thank you, Thank you, Thank you !!!
        I knew it was possible, but I just couldn’t remember how.

    Viewing 0 reply threads
    Reply To: COUNTIF

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: