counting a certain value in certain cells in a row

[themole]

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???

 

[Domski]

You can't use COUNTIF on a non-contiguous range.

This might help: http://www.mrexcel.com/forum/showthread.php?t=59926

Dom

 

[Jon von der Heyden]

Try;
=SUMPRODUCT(--(MOD(COLUMN(E8:AY8),2)),--(E8:AY8=0),--(LEN(E8:AY8)=1))

 

[Robert Mika]

Maybe simple:

=COUNTIF(E8:Y8,"0")

 

[Akashwani]

Hi,

I may be wrong here but try this...

=COUNTIF(OFFSET(C8:AY8,0,2),0)

Ak

 

[bill_ohio]

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???

Robert Mika is correct, although placing the zero in quotes isn't needed. (at least it isn't in 2007)

 

[themole]

i can't use =COUNTIF(D8:AY8,0) as it's counting the cells with "0" that i don't want it to count

 

[Jon von der Heyden]

Did you try the formula that I suggested?

 

[themole]

yeah works fine,

thanks for the help

appreciated

 

[Akashwani]

Hi,

I know my formula is wrong I have just checked it, sorry.

Jon, your formula works for me.

Ak