Results 1 to 3 of 3

Thread: COUNTIF

  1. #1
    dallasfan
    Guest

    COUNTIF

    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?

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COUNTIF

    Try this:

    {=SUM(($A$1:$A$5=20)*($F$1:$F$5=10))}

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

  3. #3
    dallasfan
    Guest

    Re: COUNTIF

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

Posting Permissions

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