Summing up values based on date criteria

[csheeri]

Hi all,

I am new to this forum so hope my post is ok

I am trying to sum up values based on date criteria. Say the date is 04/08/2017. I want to add up the total volume for that date and populate into one cell as below without having to do it manually. Does anyone know a formula for this? I am thinking along the lines of using a frequency function with a sum if function ?

Many thanks,

Cara

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Volume
[/TD]
[TD][/TD]
[TD]Date
[/TD]
[TD] Total Volume for Specific Date
[/TD]
[/TR]
[TR]
[TD]01/08/17
[/TD]
[TD]1000
[/TD]
[TD][/TD]
[TD]01/08/2017
[/TD]
[TD]1000
[/TD]
[/TR]
[TR]
[TD]01/08/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD]02/08/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03/08/17
[/TD]
[TD]500
[/TD]
[TD][/TD]
[TD]03/08/2017
[/TD]
[TD]500
[/TD]
[/TR]
[TR]
[TD]04/08/17
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD]04/08/2017
[/TD]
[TD]17
[/TD]
[/TR]
[TR]
[TD]04/08/17
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD]05/08/2017
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/08/17
[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD]06/08/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05/08/17
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]07/08/2017
[/TD]
[TD]1002
[/TD]
[/TR]
[TR]
[TD]07/08/17
[/TD]
[TD]1000
[/TD]
[TD][/TD]
[TD]08/08/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]07/08/17
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD]09/08/2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[MrKowz]

Like this?

Excel 2013/2016
	A	B	C	D	E
1	Date	Volume		Date	Total Volume for Specific Date
2	1/8/2017	1000		1/8/2017	1000
3	1/8/2017			2/8/2017	0
4	3/8/2017	500		3/8/2017	500
5	4/8/2017	2		4/8/2017	17
6	4/8/2017	10		5/8/2017	1
7	4/8/2017	5		6/8/2017	0
8	5/8/2017	1		7/8/2017	1002
9	7/8/2017	1000		8/8/2017	0
10	7/8/2017	2		9/8/2017	0
Sheet1

Cell Formulas
Range	Formula
E2	=SUMIF(A:A,D2,B:B)