Macro Help: Sum values in coloumn B falling between Text1 and Text2 in coloumn A

Good evening,

I have a bunch of worksheets with similar data-tables to the image below (albeit they are larger data sets). Can someone help me with a macro that sums the values in column B falling between rows i and k where cell Ai = text1 and cell Ak = text2? I don't want to include cells Bi and Bk in the sum, so the sum is essentially the Range("B" & (i+1) : "B" & (k-1)).

The catch is, I want to be able to use this macro on any worksheet, so text1 and text2 won't always be in the same row (they will always be in column A however).

table example.PNG

Thanks a million!

M

Try this:

Please Login or Register  to view this content.

Wow, that was fast! Thanks Akuini

You're welcome, glad to help, & thanks for the feedback.