Excel 评标基准价的公式怎么写

2025-02-25 04:00:27
推荐回答(1个)
回答1:

在求平均值的单元格输入公式:
=(SUM(B2:B30)-LARGE(B2:B30,1)-LARGE(B2:B30,2)-SMALL(B2:B30,1)-SMALL(B2:B30,2))/(COUNT(B2:B30)-4)