View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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

--
HTH

Bob Phillips

"thanks" wrote in message
...
How can I count just some cells in the same row that have a condition?

ex:

A B C D E F
1 8 7 3 7 10

It should just count cells B, D and F and the condition is that the value
should be =7