我想要求B列前两位是34且C列前两位是12的D列求和公式怎么算
用SUMPRODUCT吧
=SUMPRODUCT((LEFT(B2:B9,2)*1=34)*(LEFT(C2:C9,2)*1=12)*D2:D9)