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?

"csimont" wrote:

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.

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:

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.

--

Dave Peterson