G
Guest
I need to have it look at one cell at a time, but link 20 cells in the formula.
It is supposed to count the number cells that contain an X.
I can't use the range (K6:EN6) because of a similar =COUNTIF function that
will run on the same row.
Example
=COUNTIF((K6,R6,Y6,AF6,AT6,BA6,BH6,BO6,BV6,CC6,CJ6,CQ6,CX6,DE6,DL6,DS6,EG6,EN6),"X")
I get the #VALUE! error when I try this.
I tried making each cell a range (J6:K6,Q6:R6) and so on, but still get the
same error.
It is supposed to count the number cells that contain an X.
I can't use the range (K6:EN6) because of a similar =COUNTIF function that
will run on the same row.
Example
=COUNTIF((K6,R6,Y6,AF6,AT6,BA6,BH6,BO6,BV6,CC6,CJ6,CQ6,CX6,DE6,DL6,DS6,EG6,EN6),"X")
I get the #VALUE! error when I try this.
I tried making each cell a range (J6:K6,Q6:R6) and so on, but still get the
same error.