software

I hope someone out there can help!
I want to write a macro that performs the sumif function on files in which
the range changes from worksheet to worksheet. Each worksheet that contains a
variable number of rows. At the end of the worksheet, I would like to have a
macro to sumif column L through column Z (dependent on column A). One
worksheet might have 15 rows and another might have 300 rows. The criteria in
column A is text and column L through column Z is numerical : it is the
number of rows that change.
Can anyone help write the macro to accomplish this task?

quot;csimontquot; wrote:

gt; I hope someone out there can help!
gt; I want to write a macro that performs the sumif function on files in which
gt; the range changes from worksheet to worksheet. Each worksheet that contains a
gt; variable number of rows. At the end of the worksheet, I would like to have a
gt; macro to sumif column L through column Z (dependent on column A). One
gt; worksheet might have 15 rows and another might have 300 rows. The criteria in
gt; column A is text and column L through column Z is numerical : it is the
gt; number of rows that change.
gt;
gt;

Why not just use the whole column?

And if you put the totals at the top (row 1), you can use row 2 to 65536.csimont wrote:
gt;
gt; I hope someone out there can help!
gt; I want to write a macro that performs the sumif function on files in which
gt; the range changes from worksheet to worksheet. Each worksheet that contains a
gt; variable number of rows. At the end of the worksheet, I would like to have a
gt; macro to sumif column L through column Z (dependent on column A). One
gt; worksheet might have 15 rows and another might have 300 rows. The criteria in
gt; column A is text and column L through column Z is numerical : it is the
gt; number of rows that change.

--

Dave Peterson