Summing values according to dates

Fridrik · Apr 19th, 2002, 05:43 AM

I have a small summing problem. I'm trying to sum values per dates but the range of the dates are variable, ie. more than one value can exist for each date. For example A1:A5 contains (10.1.2001; 11.1.2002; 12.1.2002; 12.1.2002; 13.1.2002)
and B1:B5 contains (2804; 198; 1176; 702; 1983)
How can I get 4 sums out of this array with the 12th date summing up correctly.

paulyf · Apr 19th, 2002, 06:44 AM

You could use the Data->Subtotals function.

Cheers - Paul

Mudface · Apr 19th, 2002, 06:47 AM

A pivot table might be good for this also. Plenty of good tips for PT's on the main Mr Excel site.

Albert 1 · Apr 19th, 2002, 06:51 AM

In column C: put all the dates of the month.
In D1: put =SUMIF(A:A,"="&$C1,B:B)
Copy this formula down.

[ This Message was edited by: Albert 1 on 2002-04-19 05:53 ]

Fridrik · Apr 19th, 2002, 07:44 AM

Thanks, this was exactly what I was looking for.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 05:43 AM	#1
Fridrik New Member Join Date: Apr 2002 Posts: 2	I have a small summing problem. I'm trying to sum values per dates but the range of the dates are variable, ie. more than one value can exist for each date. For example A1:A5 contains (10.1.2001; 11.1.2002; 12.1.2002; 12.1.2002; 13.1.2002) and B1:B5 contains (2804; 198; 1176; 702; 1983) How can I get 4 sums out of this array with the 12th date summing up correctly.

Apr 19th, 2002, 06:44 AM	#2
paulyf New Member Join Date: Mar 2002 Location: Paul Posts: 34	You could use the Data->Subtotals function. Cheers - Paul

Apr 19th, 2002, 06:47 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	A pivot table might be good for this also. Plenty of good tips for PT's on the main Mr Excel site.

Apr 19th, 2002, 06:51 AM	#4
Albert 1 Board Regular Join Date: Feb 2002 Posts: 390	In column C: put all the dates of the month. In D1: put =SUMIF(A:A,"="&$C1,B:B) Copy this formula down. [ This Message was edited by: Albert 1 on 2002-04-19 05:53 ]

Apr 19th, 2002, 07:44 AM	#5
Fridrik New Member Join Date: Apr 2002 Posts: 2	Thanks, this was exactly what I was looking for.