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!!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

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
 

Forum statistics

Threads
1,144,364
Messages
5,723,937
Members
422,527
Latest member
TotalBeginner201

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top