Subtotal and Sumif with variable range

[camandab]

Hello,

I am stumped on an issue. I'm trying to build in a formula into a macro I have. There are a few worksheets that have 2 sections of data. The formula resides in between these sections. For example, section 1 of data will begin in row 2 and go to row 1000, section 2 will begin in row 1009 and go to row 2081, and the formula will be in row 1005. So the formula in row 1005 should sum or subtotal the data in section 1 (say L2:L1000) and the data in section 2 (say L1009:L2081). I'll also need to create another formula in row 1007 that will contain a sumif formula

Is there a way this can be done so I can have variable ranges between worksheets? Any help will be much appreciated!

 

[music43]

Yes it sounds pretty reasonable - what are the sumifs?

 

[camandab]

Sum column L if the values in column F are equal to 0 or greater than 900. Thanks in advance for your help!

 

[music43]

Cells(1, 12).End(xlDown).Offset(2, 0).Value = WorksheetFunction.Sum(Range(Cells(1, 12), Cells(1, 12).End(xlDown)))

This is just an example of vba to sum the variable length data in col L (section 1).

Is the data in col F grouped together and is it the total or the individual numbers that must exceed 900?

 

[camandab]

The data in column F is grouped together and the individual numbers must be greater than 900.