回复：在线解决Excel疑难问题

例如下图：我要求病检费的合计值（这个合计会变化，不固定在I列的）要怎么计算？
求大佬帮帮忙！！！
ps：最后计算的的值在另外一张表格（不在同一张表）

求指点 数字怎么对齐

楼主你好，请问怎么求一组数的秩？

怎么分割单元格，我就是想把报告编号跟后面的编号各自分开！该怎么操作？

练习二求个思路和能用到的函数。
目前用的是IF函数的叠加，很烦。。附公式：练习2 a后面一格的。
=(IF(AND(B2>5,B2<10),"A="&B2,"")&IF(IF(AND(B2>5,B2<10),"A="&B2,"")="A="&B2,",",""))&(IF(AND(C2>5,C2<10),"B="&C2,"")&IF(IF(AND(C2>5,C2<10),"B="&C2,"")="B="&C2,",",""))&(IF(AND(D2>5,D2<10),"C="&D2,"")&IF(IF(AND(D2>5,D2<10),"C="&D2,"")="C="&D2,",",""))&(IF(AND(E2>5,E2<10),"D="&E2,"")&IF(IF(AND(E2>5,E2<10),"D="&E2,"")="D="&E2,",",""))&(IF(AND(F2>5,F2<10),"E="&F2,"")&IF(IF(AND(F2>5,F2<10),"E="&F2,"")="E="&F2,",",""))&IF((IF(AND(B2>5,B2<10),"A="&B2,"")&IF(IF(AND(B2>5,B2<10),"A="&B2,"")="A="&B2,",",""))&(IF(AND(C2>5,C2<10),"B="&C2,"")&IF(IF(AND(C2>5,C2<10),"B="&C2,"")="B="&C2,",",""))&(IF(AND(D2>5,D2<10),"C="&D2,"")&IF(IF(AND(D2>5,D2<10),"C="&D2,"")="C="&D2,",",""))&(IF(AND(E2>5,E2<10),"D="&E2,"")&IF(IF(AND(E2>5,E2<10),"D="&E2,"")="D="&E2,",",""))&(IF(AND(F2>5,F2<10),"E="&F2,"")&IF(IF(AND(F2>5,F2<10),"E="&F2,"")="E="&F2,",",""))="","","。")

您好，这个要用什么公式呢？

=SQRT(SUM((B2:B10/SUM(B:B))^2))*100这个公式错了吗