Forum Discussion
Macro for adding columns with variable rows
Hi! I am trying to create a macro that will subtotal columns I and L where column B contains the word "summary". is this possible?!?!?
11 Replies
Perhaps
=SUMIF(B2:B100, "summary", I2:I100)+SUMIF(B2:B100, "summary", L2:L100)
Adjust the ranges as needed.
