Try this:

=SUMPRODUCT(--(MOD(COLUMN(C3:M3)-COLUMN(C3),2)=0),--(C3:M3=1))

--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
Okay, so I think my issue with my COUNTIF is that the cells are not next
to
each other. This is my range: (C3,E3,G3,I3,K3,M3).

What I want to do is range all the cells in that range that have data
equivalent to 1.00.

What I am thinking is =COUNTIF(C3,E3,G3,I3,K3,M3, "=1"). But unfortunately
that doesn't work.

Thanks