Using variables in SumIf

I am trying to put a SUMIF statementin VBA into a moving range of cells as the program cycles through. Therefor I need the criteria of the SUMIF formula to change as well. I want to put variables in for the range in the formula so as the variable lastRow increments, the range the formula searches also increments with that. Any suggestions?

ie

Please Login or Register  to view this content.

Try making all the inner quotes equal double quotes like:

Please Login or Register  to view this content.

hth

Here is the piece that has the sum if and the variable used. The rest of the macro is long and proprietary so I can't post it.
I am going by the logic of the sumif formula of sumif(range to be searched, seach for this, sum this range)

Please Login or Register  to view this content.

This way as the variables for lastrow and openrow increase, the formula will move down the sheet and the criteria range will expand.

Does:

Please Login or Register  to view this content.

work?

ngoellner,

Please use code tags around your code snippets... I have corrected them so far.

Try:

Please Login or Register  to view this content.

Maybe this at a guess

Please Login or Register  to view this content.

I figured out the problem. When setting the variables

Please Login or Register  to view this content.

It needed the .address extention

Please Login or Register  to view this content.

It was picking up the value of the cells and making an incorrect range rather than getting the location of that cell to complete the second half of the range.

Thanks for the help and the quick responses