怎么用vba做成绩统计

Question

如题所述

Answer 1

依截图说明要求：

<60人数：B13=SUM(COUNTIF(B3:B12,"<60"),COUNTIF(D3:D12,"<60"))

>=90人数：B14=SUM(COUNTIF(B3:B12,">=90"),COUNTIF(D3:D12,">=90"))

及格率：B15=TEXT(SUM(COUNTIF(B3:B12,">=60"),COUNTIF(D3:D12,">=60"))/COUNT(B3:B12,D3:D12),"0.0%")

最高分：=MAX(B3:B12,D3:D12)

如果学号都大於成绩或学号为文本格式，<60人数可简化：

B13=COUNTIF(B3:D12,"<60")