Results 1 to 8 of 8

Thread: And vs Or and Not Conditions

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-13-2012, 09:04 AM #8
    Opv
    Opv is offline
    VBAX Expert
    Joined
    Feb 2010
    Posts
    696
    Location
    Quote Originally Posted by xld
    NOTs in SUMPRODUCT and other array formulas can be quite tricky.

    Paul is right, the <> version that you are using is comparing each of the constant values against each of the cell values, so many are being counted multiple times.
    Thanks. I see that now.

    Quote Originally Posted by xld
    In full, to get your count

    =SUMPRODUCT(--(MyContacts!$B$1:$B$40<>""),--(ISNA(MATCH(MyContacts!$B$1:$B$40,{"Teacher","NA",1967,1976},0))))
    Amazing stuff! Thanks.
    Last edited by Aussiebear; 04-05-2025 at 03:46 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules