CountIf using non-adjacent cells as a range

[hnetel]

I am trying to use a CountIf statement where the range in which I am counting consists of cells that are not adjacent. I could do this with a named range, but this is in a case where I want to be able to copy the formala to a bunch of different cells without having to create many named ranges ......... any help would be appreciated.

 

[Domenic]

Can you specify which cells you want to evaluated?

 

[hnetel]

For example I want to count the number of times I get the word "Pass" in cells A1,C1,E1,G1 ........ all odd columns.

 

[just_jon]

=SUMPRODUCT(--(MOD(COLUMN(A1:IV1),2)<>0),--(A1:IV1="Pass"))

 

[Aladin Akyurek]

For example I want to count the number of times I get the word "Pass" in cells A1,C1,E1,G1 ........ all odd columns.

=SUMPRODUCT(--(MOD(COLUMN(A1:G1)-COLUMN(A1)+0,2)=0),--(A1:G1="Pass"))

 

[hnetel]

Wow you guys are amazing! Thanks!

Quick question, what is the "--" do?

Thanks.

 

[Aladin Akyurek]

Wow you guys are amazing! Thanks!

Quick question, what is the "--" do?

Thanks.

See if this helps:

http://www.mrexcel.com/board2/viewtopic.php?t=133602

 

[PaddyD]

"... all odd columns."

See:

http://www.mrexcel.com/board2/viewtopic.php?t=29977

for a method you couild use if you can't take advantage of that sort or regularity in the data.