求excel公式我的土办法=SUM(BC2*BD2+BC3*BD3*+BC4*BD4+BC5*BD5+BC6*BD6+BC7*BD7+BC8*BD8+BC9*BD9+BC10*BD10+BC11*BD11+BC12*BD12+BC13*BD13+BC14*BD14+BC15*BD15+BC16*BD16+BC17*BD17+BC18*BD18+BC19*BD19+BC20*BD20+BC21*BD21+BC22*BD22+BC23*BD23+BC24*BD24+BC25*BD25+BC26*BD26+BC27*BD27+BC28*BD28+BC29*BD29+BC30*BD30+BC31*BD31+BC32*BD32+BC33*BD33+BC34*BD34+BC35*BD35+BC36*BD36+BC37*BD37+BC38*BD38+BC39*BD39+BC40*BD40+BC41*BD41+BC42*BD42+BC43*BD43+BC44*BD44+BC45*BD45+BC46*BD46+BC47*BD47+BC48*BD48+BC49*BD49+BC50*BD50+BC51*BD51+BC52*BD52+BC53*BD53+BC54*BD54+BC55*BD55+BC56*BD56+BC57*BD57+BC58*BD58+BC59*BD59+BC60*BD60+BC61*BD61+BC62*BD62+BC63*BD63+BC64*BD64+BC65*BD65+BC66*BD66+BC67*BD67+BC68*BD68+BC69*BD69+BC70*BD70+BC71*BD71+BC72*BD72+BC73*BD73+BC74*BD74+BC75*BD75+BC76*BD76+BC77*BD77+BC78*BD78+BC79*BD79+BC80*BD80+BC81*BD81+BC82*BD82+BC83*BD83+BC84*BD84+BC85*BD85+BC86*BD86+BC87*BD87+BC88*BD88+BC89*BD89+BC90*BD90+BC91*BD91+BC92*BD92+BC93*BD93+BC94*BD94+BC95*BD95+BC96*BD96+BC97*BD97+BC98*BD98+BC99*BD99+BC100*BD100)能不能有简单一点的公式完成
网友回答
【答案】 =sumproduct(bc2:bc100,bd2:bd100)