I have a spreadsheet that has transactions on it. Each line has 2 columns - an amount and the week end
Each week can have different number of transactions.
I've gotten into putting a solid horizontal line between weeks.
Is there a way to sum a column that is between 2 solid lines? Or sum the cells with the same week end? I'd like to not have to edit the formula each week. Just cut and paste on the first line of the new week. so 'sum this row, with date x and each row after till the date changes'.
So how to sum on a varlable number of rows?
Ideas?