"kuansheng" wrote in message
oups.com...
THanks a million that is what i am looking for. Could you guide me how
this formula works?

Su

=SUMPRODUCT(--(MOD(COLUMN(I4:U4),2)=1),--(I4:U40))=7

Since the range you're interested in is every other column starting in
column I through column U, the MOD function checks the column number and
makes sure only the defined columns you want are included in the
calculation.

There are a total of 7 columns that fit the criteria so we need to check
that the total number of entries that meet the criteria equals 7.

Biff