I have two sections on a worksheet. In row 12, columns A:F I have the word "Cash" and in row 33 columns A:F i have the word "Credit Cards". In between are cash and credit card transactions respectively. In cell A1 i have the cash total and cell A2 i have credit card totals. However every month or so there may be more rows added within the cash section. Is there a formula with OFFSET or another function that will expand down to cash until the word "Credit Cards" or any other way to pick up inserted columns in the cash column so i do not have to maintain the SUM formula in A1?. The design of the worksheet cannot be change because it is more complicated than what I am describing, but I am simplifying it to solve this problem.
Thanks in advance.
Bookmarks