Results 1 to 10 of 10

Thread: COUNTIF With Multiple Criteria Across Multiple Columns

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Apr 2013
    Posts
    8
    Rep Power
    0

    Question COUNTIF With Multiple Criteria Across Multiple Columns

    Need help with the below formula. Not sure what the problem is since its returning 0 when it should return 2 since there are two rows that meet the four criterias that I'm looking for (W85NAA, OD, 3A., and MSG). Im using this as an example since I have a huge list with all the criterias below.

    B1=W85NAA
    B2=W73P01
    B3=W9G9AA
    B4=WSR7AA

    K1=DUE
    K2=OD

    U1=1A. Pending Separation
    U2=2A. Discharged
    U3=3A. Pending Loss
    U4=4A. Medical
    U5=5A. Transfer

    E1=CSM
    E2=SGM
    E3=MSG
    E4=SFC
    E5=SSG
    E6=SGT

    A1=SUMPRODUCT(COUNTIFS(Master!$B$1:$B$4,"*W85NAA*" ,Master!$K$1:$K$2,"*OD*",Master!$U$1:$U$5,{"*1A*", "*2A*","3A*","4A*","5A*","6A*","7A*"},Master!$E$1: $E$6,{"SGM";"CSM";"1SG";"MSG";"SFC";"SSG";"SGT"}))
    Last edited by GymWrecker; 11-10-2013 at 09:49 PM.

Similar Threads

  1. Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  2. Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  3. Replies: 7
    Last Post: 05-15-2013, 02:56 PM
  4. Replies: 3
    Last Post: 03-12-2013, 12:54 PM
  5. Replies: 2
    Last Post: 06-14-2012, 04:10 AM

Posting Permissions

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