=SUMPRODUCT((TEXT(A2,”e年m月”)=TEXT(明细!$A$2:$A$1067,”e年m月”))*1)
=SUMPRODUCT((条件=条件区域)*1)
=SUMPRODUCT((TEXT(A2,”e年m月”)=TEXT(明细!$A$2:$A$1067,”e年m月”))*明细!$B$2:$B$1067)
=SUMPRODUCT((条件=条件区域)*求和区域)
=SUMPRODUCT((TEXT(A2,”e年m月”)=TEXT(明细!$A$2:$A$1067,”e年m月”))*明细!$C$2:$C$1067)
=SUMPRODUCT((条件1=条件区域1)*(条件2=条件区域2)*(条件n=条件区域n))
=SUMPRODUCT((条件1=条件区域1)*(条件2=条件区域2)*(条件n=条件区域n)*求和区域)
微信扫一扫加关注,Office自学网官方微信公众号, 专注分享软件安装和视频教程,让你一号在手,办公无忧!