I want to add up a column of data. I know how to sum that data. But where I'm lost is this. I want to keep all the daily "sums" and then produce a chart of the daily sums to show historical chart.
I want to add up a column of data. I know how to sum that data. But where I'm lost is this. I want to keep all the daily "sums" and then produce a chart of the daily sums to show historical chart.
Consider using the SUBTOTAL() function in place of SUM(). If that doesn't work for you please post a copy of your workbook to better explain the requirement.