Too Few Arguments Error

[mcgonma]

I have the following formula that, when I add one more cell to it, I get an error message that "You've added too few arguments for this function". But as soon as I delete "CR3," after "CM3" the formula works.

=IF(COUNTIFS(AM3,AO3,AT3,AU3,AY3,BG3,BK3,BO3,BP3,BQ3,BR3,BT3,BU3,BW3,BY3,CC3,CG3,CH3,CM3,FALSE),"YES","-")

 

[mcgonma]

The contiguous range will not work for me because columns AX-DI represent a complete set of identification criteria about a person that I'm looking to see if they are met; so for each column within AX-DI, if the person does meet the criteria of the respective column the formula returns a result of "FALSE".


So now, what I am looking to do with the formula in AF is find people who meet a specific subset of criteria from within the larger set in AX-DI. In this particular example, the subset is the criteria of columns BA,BC,BH,BI,BL,BU,CC,CD,CF,CG,CJ,CL,CN,CR,CV,CW,DC