SUMPRODUCT? QUERY OR SUMIF, PLEASE HELP!!

chally3

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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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
 
Upvote 0
how do I do this, the mrp run column is actually a date on my spreadsheet of when we run it
 
Upvote 0
Have you used MS Query in Excel before?

Data > Get External Data > New Data Base Query
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

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
Back
Top