What are the 5 and 3 in the column side. Is the 5 the size of the block I am
reading and the 3 the third element of that array? I am asking this because
I have to perform the same operation on the following 2 columns. It worked
fine for the first element that I picked up but it does not work for the next
set of columns.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(MOD(COLUMN(C6:CU6),5)=3),--(C6:CU6="Y"))

--
Biff
Microsoft Excel MVP


"Jerry" wrote in message
...
I have a long spreadsheet and I have several columns that have text.
These
cells are not consecutive but is like every fourth cell and I have to
count
them to perform operations like calculating percentages. If i pick a
range
of cells (i.e. c6:cu6) the results are going to be wrong because along
the
range are other cells that may have the same content.
a b c d e f g h i j k l m n o
0 5 N N Y 7 3 Y N N 6 7 Y N Y
now I want to count c, h, m and do some sort of computation such as
=countif(c,h,m,"Y")
Your assistance is greatly appreciated.