I'm trying to make a sheet that'll sum up the total amount of orders in kilos week by week.
The problem is that I don't know in advance how many order that'll come in each week and therefore the summation has to be somewhat selfadjustable.
SO, I want to sum up one row comtaining orders in kilos, but only the ones that are from the same week. I want the answer from the summation to be entered into it's own column, but only in the same row as the last entered order of that week.
Hope somebody understands what I mean, and that somebody can help me with this.
/Magnus
The problem is that I don't know in advance how many order that'll come in each week and therefore the summation has to be somewhat selfadjustable.
SO, I want to sum up one row comtaining orders in kilos, but only the ones that are from the same week. I want the answer from the summation to be entered into it's own column, but only in the same row as the last entered order of that week.
Hope somebody understands what I mean, and that somebody can help me with this.
/Magnus