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))
Bookmarks