|
发表于 2013-1-5 14:17
|
显示全部楼层
本楼为最佳答案
SUMPRODUCT多条件求和
<1year- =SUMPRODUCT(($H$2:$H$16=A2)*(DATEDIF($J$2:$J$16,$F$1,"Y")<1)*$I$2:$I$16)
复制代码 1-2年- =SUMPRODUCT(($H$2:$H$16=A2)*(DATEDIF($J$2:$J$16,$F$1,"Y")>=1)*(DATEDIF($J$2:$J$16,$F$1,"Y")<=2)*$I$2:$I$16)
复制代码 over 2 years- =SUMPRODUCT(($H$2:$H$16=A2)*(DATEDIF($J$2:$J$16,$F$1,"Y")>2)*$I$2:$I$16)
复制代码 |
|