在C1中写=SUMIFS(B2:B14,A2:A14,"<=3)
在C2中写=SUMIFS(B2:B14,A2:A14,">3",A2:A14,"<=5")
在C3中写=SUMIFS(B2:B14,A2:A14,">5",A2:A14,"<=8")
在C4中写=SUMIFS(B2:B14,A2:A14,">8")
这样就可以在四个单元格中得到四组和
<=3: =sumif(a:a,"<=3",b:b)
3-5: =sumifs(b:b,a:a,">3",a:a,"<=5")
5-8: =sumifs(b:b,a:a,">5",a:a,"<=8")
>8: =sumif(a:a,">8",b:b)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024