=SUMPRODUCT((MOD(COLUMN(C2:L20),2)=1)*(C2:L20="yes "))

--
__________________________________
HTH

Bob

"Manos" wrote in message
...
Dear All

I have a worksheet where all the values produced by list and all the cells
have either yes or no.
In the columns i have scenario by person, so imagine in columns C,E,G, I,
K
i have the scanrio Budget and in columns D, F,H,J,L i have the scenario
Actual.

Who can i count all the yes for scenario budget (C,E,G, I, K) and all the
yes for the scenario actual (D, F,H,J,L) ?

I tried the count if but it doesn't accept seperatly cells. I need a
dynamic
way.

Thanks in advance for your help