CountIf using every other column

  • Thread starter Thread starter duketter
  • Start date Start date
D

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!
 
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))
 
Back
Top