In col A I have a bunch of dates. From Jan 1 2016 to Dec 31 2017. In the format 1/20/2017 etc.
In col B I have the expenses of that date.
I want to break this down by month, using formulas not pivot tables. So in col C I've written Dec-17, Nov-17, etc.
What formula would I type in col D, to get the appropriate values? I've tried a sumif but I cant figure out how to make this work.
Thanks!
[TABLE="width: 500"]
<tbody>[TR]
[TD]12/1/2017[/TD]
[TD]$50[/TD]
[TD]Dec-17[/TD]
[TD]what formula goes here?[/TD]
[/TR]
[TR]
[TD]11/20/2017[/TD]
[TD]$60[/TD]
[TD]Nov-17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/1/2016[/TD]
[TD]$75[/TD]
[TD]Oct-17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/20/2016[/TD]
[TD]0[/TD]
[TD]Sep-17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/31/2016[/TD]
[TD]0[/TD]
[TD]Aug-17[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In col B I have the expenses of that date.
I want to break this down by month, using formulas not pivot tables. So in col C I've written Dec-17, Nov-17, etc.
What formula would I type in col D, to get the appropriate values? I've tried a sumif but I cant figure out how to make this work.
Thanks!
[TABLE="width: 500"]
<tbody>[TR]
[TD]12/1/2017[/TD]
[TD]$50[/TD]
[TD]Dec-17[/TD]
[TD]what formula goes here?[/TD]
[/TR]
[TR]
[TD]11/20/2017[/TD]
[TD]$60[/TD]
[TD]Nov-17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/1/2016[/TD]
[TD]$75[/TD]
[TD]Oct-17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/20/2016[/TD]
[TD]0[/TD]
[TD]Sep-17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/31/2016[/TD]
[TD]0[/TD]
[TD]Aug-17[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]