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"}))
Bookmarks