最近做性能测试处理后续数据,用到了excel的一些公式,记录一下:
1、对数据进行分段:
LOOKUP(G2,{0,0.5,0.7,0.8,0.95,1,999999},{"A","B","C","D","E","F","G"})
2、当A列符合某条件时,求B列平均值:
AVERAGEIF(A10:A609,"=100000",B10:B609)
3、当A列符合某条件时,求B列总和:
SUMIF(A10:A609,"=100000",B10:B609)
4、A列满足某条件的数量:
数值型----COUNTIF(A10:A609,"=100000")
文本型----COUNTIF(L2:L3423,"A")