SUMIFS between dates

[Hudco]

Hi guys,
I have this formula which is not returning any results
=SUMIFS($E$4:$E$339,$D$4:$D$339,"="&K$3,$C$4:$C$339,">"&$J4,$C$4:$C$339,"<="&$J5)

Column E are Values
Column D Names of staff
Cell K3 Name of specific staff member
Column C are Dates
Cells J4 and J5 are end dates of two months (June & July)

I am trying to get the sum of the values in column E for each month for each employee.

Can anyone help, thank you

 

[Norie]

What exactly do you have in J4 and J5?

 

[amitlonkar]

Please help to find out particular month in two dates..
examples there is two dates in A2 and B2 column - 01/01/2017 in A2 column and 05/31/2017 in B2 column and i want to check if Particular month is falling in date or not... if i want to find out April 2017 month in both dates so what is a formula for this.. Please suggest

 

[Hudco]

J4 has 30/06/2012
J5 has 31/07/2012

 

[amitlonkar]

Please share formula....

 

[Norie]

If the dates in column C cover the year 2012 then your formula should work.

 

[Hudco]

Hi Norie, the dates cover from 1/7/2012 to 30/06/2013 and yes, from everywhere I have looked the formula should work. I have checked the formatting and the date cells are all set to date etc.

 

[Norie]

Is calculation set to Automatic?

Are the values in the cells (column C and J4 & J5) actually date values?

I know you say they are formatted as date but that doesn't mean they are 'real' dates.

 

[Hudco]

Thanks Norie, the original data was a dump from MYOB accounting which uses some strange formats.

Problem solved, thanks