Hi there,
I have a date column and a Dollar column. I want to sum based on the month and year. So in the below example for Jan 2019 i would get the answer of $2300. I believe the Sum Production or Sum if function needs to be used. Can any one help with this one?[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]$ value[/TD]
[/TR]
[TR]
[TD]01-01-2019[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]01-02-2019[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]01-20-2019[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]02-05-2019[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]05-07-2019[/TD]
[TD]4000[/TD]
[/TR]
[TR]
[TD]15-07-2019[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a date column and a Dollar column. I want to sum based on the month and year. So in the below example for Jan 2019 i would get the answer of $2300. I believe the Sum Production or Sum if function needs to be used. Can any one help with this one?[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]$ value[/TD]
[/TR]
[TR]
[TD]01-01-2019[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]01-02-2019[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]01-20-2019[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]02-05-2019[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]05-07-2019[/TD]
[TD]4000[/TD]
[/TR]
[TR]
[TD]15-07-2019[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]