#### chally3

##### Board Regular
Your help please, I have a spreadsheet that is updated weekly which basically counts the requisitions in our dept & age. What I am trying to do is count how many are processed each week. This is not a simple calculation of 1 weeks total minus the previous weeks total.

Book1
ABCDE
1MRPRUN>1WEEK1-2WEEKS2-4WEEKS4+
2125613305
326702319
4355110306
5424478311
Sheet1

I will try to explain more

if you look at the data, MRP 1 shows 25 (new requisitions – under 1 week) etc
if this 25 requisitions were not actioned in week 1, they would move to ‘1-2 WEEKS column’ on ‘MRP RUN 2’, as 25 were actioned this is shown as ‘0’

If you look at the data, MRP 3 shows 55 new requisitions
IfColumn C shows 1, 66 were actioned that week.

I Need help with a calculation which shows how many were actioned.

Can this be done, as its difficult to explain!!

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

ANYONE??

Edit

#### MarkAndrews

##### Well-known Member
You could use MS Query, add in a date parameter liked to the cells which will contain your date, the query will return all data between those dates & changes as you change the dates

You could then simply have a count of the entries down whatever column you desire to give you your total for the period

#### chally3

##### Board Regular

how do I do this, the mrp run column is actually a date on my spreadsheet of when we run it

#### MarkAndrews

##### Well-known Member
Have you used MS Query in Excel before?

Data > Get External Data > New Data Base Query

#### barry houdini

##### MrExcel MVP
Isn't the number actioned in week 1

=SUM(B2:E2)-SUM(C3:E3)

#### chally3

##### Board Regular
PERFECT THANK YOU!!

Replies
0
Views
160
Replies
23
Views
285
Replies
18
Views
203
Replies
7
Views
65
Replies
19
Views
283