第3个回答 2015-05-28
使用下列公式之一
=SUMPRODUCT(--(LEFT(B1:B5)="1"))
=SUMPRODUCT(0+(LEFT(B1:B5)="1"))
=SUMPRODUCT(1*(LEFT(B1:B5)="1"))
=SUMPRODUCT((LEFT(B1:B5)="1")-0)
=SUMPRODUCT((LEFT(B1:B5)="1")/1)
=SUMPRODUCT((LEFT(B1:B5)="1")^1)
=SUMPRODUCT(0+(LEFT(B1:B5)-1=0))
=SUMPRODUCT(1*(LEFT(B1:B5)-1=0))
=SUMPRODUCT((LEFT(B1:B5)-1=0)+0)
=SUMPRODUCT((LEFT(B1:B5)-1=0)/1)
=SUMPRODUCT((LEFT(B1:B5)-1=0)^1)
=SUMPRODUCT(--(LEFT(B1:B5)-1=0))