# SumIfs with Between Date Range

I have the following function =IFERROR(SUMIFS(\$L:\$L,\$D:\$D,"*fj*b*",\$F:\$F,"*14",\$E:\$E,"<> hld",\$C:\$C,"mys")/COUNTIFS(\$D:\$D,"*fj*b*",\$F:\$F,"*14",\$E:\$E,"<> hld",\$C:\$C,"mys"),0)

and need to add the additional criteria of between the date range of 2/2/14 and 5/3/14 and the date range is found in column K. What would be the best way to add the criteria?

Thanks
###### Who is Participating?

x

Commented:
Hi,

pls try

``````=IFERROR(SUMIFS(\$L:\$L,\$D:\$D,"*fj*b*",\$F:\$F,"*14",\$E:\$E,"<> hld",\$C:\$C,"mys",\$K:\$K,">="&DATE(2014,2,2),\$K:\$K,"<="&DATE(2014,5,3))/COUNTIFS(\$D:\$D,"*fj*b*",\$F:\$F,"*14",\$E:\$E,"<> hld",\$C:\$C,"mys",\$K:\$K,">="&DATE(2014,2,2),\$K:\$K,"<="&DATE(2014,5,3)),0)
``````
0

Commented:
Hi,

you say you have a date range but only one column

How's that?

Regards
0

Author Commented:
Column K represent an opening date and my goal is to only add if the date falls in the first quarter which is Feb - May 3, is it possible to update the equation with only one date column?
0

Author Commented:
Thanks that worked!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.