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