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
jmac001Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor 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)

Open in new window

0
 
Rgonzo1971Commented:
Hi,

you say you have a date range but only one column

How's that?

Regards
0
 
jmac001Author 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
 
jmac001Author Commented:
Thanks that worked!
0
All Courses

From novice to tech pro — start learning today.