Month to date totals

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
I have a table containing information about a series of companies. The company numbers are in column 1. I have reporting dates in column 2. In column 3 and 4 are planned and actual numbers. I want to report the month to date totals for each of the companies. The table is sorted based on company number then by date. I tried sumif but was unable to determine how to drive the argument for the date range. Also, I only want to sum relevant cells based on meeting the criteria of current month and company number. Anyone have a suggestion?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
It sounds like you simple task, it would be a lot easier to follow if you posted up a short example using the colo worksheet utility noted below. It sure helps a lot to see visually the data you have to work with and the expected outcome you wish to see, rather than going back and forth several times. There are a lot of experience users on this forum.

good luck
pll
 

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
Here is the file, I would like to get the total of NGS for each company within a month range. So I would like to look at all of company 2 for 8/16/2002 and 8/17/2002.
Book1
ABCDEFGHIJK
1CompanyLineDateNGSBuiltPullsReceiptsCancelsOrderboardPastDueCustPastDuePlant
22108/15/021571600814971112445
32208/15/0247540004918124
49108/15/023349027239564848
511108/15/0200000000
614108/15/0240005016971510
720108/15/026370036506944169
862108/15/025364111233872194148
963108/15/025050007700119
1065108/15/022828001231710475
1165208/15/020460042290360357
122108/16/0215415801990975114327
132208/16/0247500004486618
149108/16/025036087039945347
1511108/16/0200000000
1614108/16/020000616681112
1720108/16/024846030502247220
1862108/16/0252001903882198149
1963108/16/02000007700111
2065108/16/0228403023207371
2165208/16/02000002285339357
Sheet1


I have approximately 2 months of data at any given time.
 

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
I have solved the problem quite easily with the conditional sum wizard. Maybe I was looking for a complex solution where none was needed.
 

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
I have solved the problem quite easily with the conditional sum wizard. Maybe I was looking for a complex solution where none was needed.
 

Forum statistics

Threads
1,144,509
Messages
5,724,770
Members
422,577
Latest member
kayth891

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