sum by month issue

[anawarulhassan]

Hi,

I am trying to sum by month and formula is returning the value as 0. My formula is as following:-

{=SUMIFS($H$19:$H38,$B$19:$B$38,">="&$M19,$B$19:$B$38,"<="&EOMINTH$M19,0))}

Column H is my sale value
Column B has dates 21/09/2018
Column M has months list, September, October etc...

Advance thank you

 

[anawarulhassan]

small correction last part of formula is EOMONTH and not EOMINTH written earlier

 

[Dave Patton]

What is in M19?
Formula should not be Array Entered.
N.B. You can format M19 to display just the Year.

Excel 2010
	B	H	I	M	N
19				1-Sep-18	1-Oct-18
20	21-Sep-18	1250		3250	2500
21	20-Oct-18	1500
22	5-Sep-18	2000
23	20-Oct-18	1000
9c

Cell Formulas
Range	Formula
M20	=SUMIFS($H$19:$H38,$B$19:$B$38,">="&M19,$B$19:$B$38,"<="&EOMONTH(M19,0))
N20	=SUMIFS($H$19:$H38,$B$19:$B$38,">="&N19,$B$19:$B$38,"<="&EOMONTH(N19,0))

 

[anawarulhassan]

perfect all working now. thank you so much

 

[anawarulhassan]

M19 had the months to sum into and Column M had list of months....all ok now

 

[Dave Patton]

slightly different spin on the same formula.

Excel 2010
	B	H	I	M	N	O
19				1-Sep-18	1-Oct-18	1-Nov-18
20	21-Sep-18	1250		3250	2500
21	20-Oct-18	1500
22	5-Sep-18	2000
23	20-Oct-18	1000
9cc

Cell Formulas
Range	Formula
M20	=SUMIFS($H$19:$H38,$B$19:$B$38,">="&M19,$B$19:$B$38,"<"&N19)
N20	=SUMIFS($H$19:$H38,$B$19:$B$38,">="&N19,$B$19:$B$38,"<"&O19)

 

[anawarulhassan]

great.....perfect....this is great