是如图意思吗？
=SUMPRODUCT((F2=Sheet1!$A$2:$A$4)*(G2=Sheet1!$B$2:$B$4)*(Sheet1!$C$2:$C$4))
PS：Sheet1!$A$2:$A$4颜色所在区域；Sheet1!$B$2:$B$4编号所在区域，Sheet1!$C$2:$C$4)数量所在区域。如下图：
