Month to date totals

[imported_unknown]

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?

 

[Brian from Maui]

Try lookin into SUMPRODUCT to sum ranges meeting two or more criteria

 

[plettieri]

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]

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
	A	B	C	D	E	F	G	H	I	J	K
1	Company	Line	Date	NGS	Built	Pulls	Receipts	Cancels	Orderboard	PastDueCust	PastDuePlant
2	2	1	08/15/02	157	160	0	81	4	9711	124	45
3	2	2	08/15/02	47	54	0	0	0	491	81	24
4	9	1	08/15/02	33	49	0	27	2	3956	48	48
5	11	1	08/15/02	0	0	0	0	0	0	0	0
6	14	1	08/15/02	40	0	0	5	0	1697	15	10
7	20	1	08/15/02	63	70	0	3	6	5069	44	169
8	62	1	08/15/02	53	64	11	12	3	3872	194	148
9	63	1	08/15/02	50	5	0	0	0	770	0	119
10	65	1	08/15/02	28	28	0	0	1	2317	104	75
11	65	2	08/15/02	0	46	0	0	4	2290	360	357
12	2	1	08/16/02	154	158	0	199	0	9751	143	27
13	2	2	08/16/02	47	50	0	0	0	448	66	18
14	9	1	08/16/02	50	36	0	87	0	3994	53	47
15	11	1	08/16/02	0	0	0	0	0	0	0	0
16	14	1	08/16/02	0	0	0	0	6	1668	11	12
17	20	1	08/16/02	48	46	0	3	0	5022	47	220
18	62	1	08/16/02	52	0	0	19	0	3882	198	149
19	63	1	08/16/02	0	0	0	0	0	770	0	111
20	65	1	08/16/02	28	4	0	3	0	2320	73	71
21	65	2	08/16/02	0	0	0	0	0	2285	339	357
Sheet1

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

 

[imported_unknown]

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]

I have solved the problem quite easily with the conditional sum wizard. Maybe I was looking for a complex solution where none was needed.