Challenging Sum-problem

[majon96]

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

 

[Fryer Tuck]

Several options, but I'm not sure that I understand the layout of your sheet.

You could have a macro that you run once a week

or

using blank rows or sheets enter IF/THEN statments that copy the number if the dates fall within a certain week. Then sum up those totals.

F.T.

 

[Foeth]

If you have your week in column A and the kilo's in columns B

=if(A(i)<>A(i+1);sumif(A(start):A(end);A(i);B(start):B(end));"")

A(i) is the selected cell , e.g. A1

A(start):A(end) can be A1:A10

PERSONAL.XLS
	A	B	C	D
1	Week	Kilo's	Total/Week
2	1	1
3	1	6
4	1	1	8
5	2	0
6	2	8
7	2	10	18
8	3	2
9	3	3
10	3	1
11	3	2	8
12	4	1
13	4	1	2
Sheet1

This message was edited by Foeth on 2002-09-27 07:14