the below formula works fine single column, need sum across columns instead:
=sumifs(srrecruiter!$f$2:$f$500,srrecruiter!$a$2:$a$500,">="&'monthly team scorecard data'!$b$2,srrecruiter!$a$2:$a$500,"<="&'monthly team scorecard data'!$c$2) i trying sum data column f2:h6 using below formula won't work there way this? thank
=sumifs(srrecruiter!$f$2:$h$6,srrecruiter!$a$2:$a$500,">="&'monthly team scorecard data'!$b$2,srrecruiter!$a$2:$a$500,"<="&'monthly team scorecard data'!$c$2)
all,
i able user on different excel board provided below solution problem works perfectly! perhaps others in future if needed.
=sumproduct(srrecruiter!$f$2:$n$6*(srrecruiter!$a$2:$a$6>='monthly team scorecard data'!$b$2)*(srrecruiter!$a$2:$a$6<='monthly team scorecard data'!$c$2))
Comments
Post a Comment