Thanks for your help guys. I don't know if I am explaining this correctly,
so i will try one more time. This is what I am working with.

Start With:
{=COUNT(IF(($C$11:$C$128620)*(C$11:C$128620),0)) }

Step 1:
Make the formula in the row below the initial one increment the column
referenced in the first part of the formula (change $C$11:$C$12862 to $D$11:
$D$12862), but leave the reference in the second part the same. I can do
this by hand, but am looking for a way to program it to eliminate the manual
part. IE:

Drag it down one row to make the formula:
{=COUNT(IF(($D$11:$D$128620)*(C$11:C$128620),0)) }

Step 2:
I understand this and I have it working in both regular Excel and with an
autofill command in VBA, but there might be a reason to increment this as
well to make Step 1 run more smoothly, I just don't know enough about it.

Drag that (From Step 1) to the right one column to make the formula:
{=COUNT(IF(($D$11:$D$128620)*(D$11:D$128620),0)) }

I want to find a way to automate the change in Step 1 either through marcos
autofill or through draging it down.

Thanks again folks!!!!!







K Dales wrote:
If I understand, this might be what you want (put this formula in A20 and you
can drag it down the rows in column A and then across the columns):
=SUM(OFFSET($A$1:$A$10,0,ROW()-20))*SUM(A$1:A$10)

I am trying to set up a macros that will increment the referenced row as the
columns are dragged down. The only problem is that I want the rows to remain
[quoted text clipped - 23 lines]

Thanks a TON!!!