"countif"

[DCII]

I was wondering if there is a simpler way to "countif"
numerous cells that are not in a continuous range. Here
is the formula I came up with that worked but it seems a
little too winded...Thanks, DCII

=CONCATENATE(SUM(COUNTIF('Individual data (2)'!
C16,"yes"),COUNTIF('Individual data (2)'!
E16,"yes"),COUNTIF('Individual data (2)'!
G16,"yes"),COUNTIF('Individual data (2)'!
I16,"yes"),COUNTIF('Individual data (2)'!K16,"yes")),"/",+
((SUM(COUNTIF('Individual data (2)'!C16,"yes"),COUNTIF
('Individual data (2)'!E16,"yes"),COUNTIF('Individual
data (2)'!G16,"yes"),COUNTIF('Individual data (2)'!
I16,"yes"),COUNTIF('Individual data (2)'!K16,"yes"))+SUM
(COUNTIF('Individual data (2)'!C16,"no"),COUNTIF
('Individual data (2)'!E16,"no"),COUNTIF('Individual data
(2)'!G16,"no"),COUNTIF('Individual data (2)'!
I16,"no"),COUNTIF('Individual data (2)'!K16,"no")))))

 

[Aladin Akyurek]

=SUMPRODUCT(--(MOD(COLUMN('Individual data
(2)'!$C$16:$K16)-CELL("Col",'Individual data
(2)'!$C$16)+0,2)=0),--('Individual data (2)'!$C$16:$K16="yes"))

would count the occurrences of "yes" by looking at every other column
starting with C16 (indicated by +0).