SUMPRODUCT? QUERY OR SUMIF, PLEASE HELP!!

chally3

Board Regular
Joined
Mar 22, 2006
Messages
151
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.

Spreadsheet as follows
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!!
 

Some videos you may like

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"

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
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
Joined
Mar 22, 2006
Messages
151

ADVERTISEMENT

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
Joined
May 2, 2006
Messages
1,963
Have you used MS Query in Excel before?

Data > Get External Data > New Data Base Query
 

Watch MrExcel Video

Forum statistics

Threads
1,113,810
Messages
5,544,425
Members
410,610
Latest member
renatha prado
Top