Cancel Create saved search Sign in Sign up Reseting focus {{ message }} albertzzzzzzzzzzzz / l2-intro-pre-ethdenver Public forked from matter-labs/l2-intro-pre-ethdenver Notifications You must be signed in to change notification settings Fork 0 Star 0 ...
到这里并没有得出我们需要的平均成绩,我们在编辑栏进行修改“=(SUMIF(B2:C4,B2,C2:C4))/D2”,这样才能得出我们要的结果85。 SUMIF函数主要注意两个范围的选择,B2:C4代表条件判断的单元格区域,B2代表指定条件表达式,C2:C4代表需要计算的数值所在的单元格区域。大家可以根据例题体会下2个区域的区别。
l2labs/multicallPublic NotificationsYou must be signed in to change notification settings Fork9 Star1 Code Issues