i'm having trouble counting certain cells within a row which contain the value "0". the cells are 2 places apart from each other in the row.
i've tried using =COUNTIF((E8,G8,I8,K8,M8,O8,Q8,S8,U8,W8,Y8,AA8,AC8,AE8,AG8,AI8,AK8,AM8,AO8,AQ8,AS8,AU8,AW8,AY8),"0")
But all i got was an error on screen
can anyone help???
i've tried using =COUNTIF((E8,G8,I8,K8,M8,O8,Q8,S8,U8,W8,Y8,AA8,AC8,AE8,AG8,AI8,AK8,AM8,AO8,AQ8,AS8,AU8,AW8,AY8),"0")
But all i got was an error on screen
can anyone help???