View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default CountIf using every other column

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

--
Biff
Microsoft Excel MVP


"duketter" wrote in message
...
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!