sumproduct subtotal offset with multiple criteria

I'm trying to modify my formula to add if a current cell in Column G isn't equal to the preceding cell in Column G as well.... In other words adding in multiple criteria statement. Anybody know how to add this to my formula?
Right now as you can tell from my formula, column L is my summing column. My formula works great, but I wanted to make it a little more robust.

Thanks,

Renee

'=SUMPRODUCT(SUBTOTAL(109,OFFSET($L10,ROW($L10:$L108)-ROW(L10),,1)),--($R10:$R108=0))

Hi -

Have you tried something like:

=SUMPRODUCT(SUBTOTAL(109,OFFSET($L10,ROW($L10:$L108)-ROW(L10),,1)),--($R10:$R108=0)*($G11:$G108<>$G10:G107))

I don't have time to test this, and it may choke on the fact the G arrays might not be the same length as the R and L arrays. You might have to tweak it to be something like ($G11:$G109<>$G10:G108)

Hi -

Would it be possible to upload a sample spreadsheet?

OK - One last try - This one works on a set of sample data that I put together.

=SUMPRODUCT(SUBTOTAL(109,OFFSET($L10,ROW($L10:$L108)-ROW(L10),,1)),--($R10:$R108=0)*($G11:G109<>$G10:G108))

This formula should work. Can you look at the sample data and tell me how it's different that what you are trying to do?

OK - Great! If you are satisfied with the outcome, please edit the thread title of this post to include SOLVED per the instructions at the bottom of this post.