# Challenging Sum-problem

#### majon96

##### Board Regular
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

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
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.

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
ABCD
1WeekKilo'sTotal/Week
211
316
4118
520
628
721018
832
933
1031
11328
1241
13412
Sheet1

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

Replies
6
Views
314
Replies
2
Views
376
Replies
9
Views
306
Replies
7
Views
397
Replies
3
Views
405

1,218,841
Messages
6,144,793
Members
450,567
Latest member
Mplz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back