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