Easy question (I think) (dependent cells)
I have a worksheet with many columns and totals for each column.
As I add new data rows within the worksheet, the "Total" cells move down. I have a section at the bottom of the worksheet that takes the Totals (above) and adds, subtracts them in order to get a reconciling amount to compare to my cash account. I cannot get these dependent cells (using the totals from above) to capture the MOVING total cells. I've tried (for ex) $K104, but when it moves to K125, the dependent cell stays at K104. I don't find anything in a 1200 page manual that shows me how to capture a moving cell total. Help? (I'm not very experienced, need I say?) |
total your spread sheet at the top row, and set your totaling cells to total sum=A1:A10000 this will allow your sum to be totaled up to 10000 rows.
Quote:
|
Quote:
If you don't have a column header: =SUM(OFFSET(B1,0,0,ROW()-ROW(B1),1)) If you have a column header: =SUM(OFFSET(B2,0,0,ROW()-ROW(B2),1)) |
All times are GMT +1. The time now is 06:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com