CountIf using every other column

[duketter]

Excel 2003 - I am trying to count the number of times the number "2" appears
in column A1, C1, E1, G1, I1, etc. I am trying to use the countif function,
but it won't work. I can't just select every other column like I need to, it
wants me to select the entire range if that makes sense.

Is there anyway I can do this and only look at every other column or every
3rd column?

Thanks!

 

[Gary''s Student]

=COUNTIF(A:A,2) + COUNTIF(C:C,2) + .......etc.

 

[Michelle]

You might also find this posting useful. They are talking about using
COUNTIF with noncontinuous ranges, and gives an alternative solution to the
one above...

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.worksheet.functions&tid=dbb14cb0-d372-4141-b296-0a82f2f1f306&cat=&lang=&cr=&sloc=&p=1

Hope this helps.

 

[T. Valko]

count the number of times the number "2" appears in

column A1, C1, E1, G1, I1, etc.

Try this:

=SUMPRODUCT(--(MOD(COLUMN(A1:I1)-COLUMN(A1),2)=0),--(A1:I1=2))