hey excel people out there I had a quick question never did anything like this in Excel before myself so here we go: I have a generated export of data that I have formatted in excel and I am making some of my eval statements of the data in excel. Now the amount of data varies from day to day but I want to somehow create a macro/formula so excel knows to sum up all the data in column K or L etc without having to factoring in the number of rows in that column. We are creating an overall keyboard/mouse macro to run that whole data export process.
even if i have over 10k rows of data? i dont want the sum to be in row 10001 when the data ends at row 2200 for a particular day.
gotcha -- if you need the sum to be in the last row (not on a summary worksheet etc...) you will need to write some kind of macro. Sorry
you could write a macro but what cesar is proposing is to move the summation cell to the top, or some summary sheet. moving to the top is easiest. for easiest way to think about it, cell A1 = sum(A2:A65536). If you already have a macro that pulls your data starting in cell A1, just make B1 = sum(A1:A65536). If there is a bunch of different date you are doing formulas on, cesar's suggestion of using a summary tab would be best.
