Macros for sumif and changing range
 

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.

Macros for sumif and changing range
 

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.

Macros for sumif and changing range
 

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