Sum by month/year

[ace09]

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?

Date	$ value
01-01-2019	500
01-02-2019	300
01-20-2019	1500
02-05-2019	2000
05-07-2019	4000
15-07-2019	200

<tbody>
</tbody>

 

[Ray Bailey]

Hi,

If you're able to add an extra column the easiest way would be to have a column with formula =EOMONTH(A2,0) the do SUMIF on that column.


Cheers

Ray

 

[jtakw]

Hi,

Assuming those are Real Date values in Column A (the last entry does Not match the rest), use SUMPRODUCT to check for Month:

Book1
	A	B	C	D	E
1	Date	$ value		Month to Sum	Result
2	1/1/2019	500		1	2300
3	1/2/2019	300
4	1/20/2019	1500
5	2/5/2019	2000
6	5/7/2019	4000
7	7/15/2019	200
Sheet212

Cell Formulas
Range	Formula
E2	=SUMPRODUCT((MONTH(A2:A7)=D2)*B2:B7)

Change D2 to the Number corresponding to whichever Month you want to SUM.