Excel如何用函数统计人数,出现多次只算一人?答:=多项查询($C:$C,$B:$B,E$17,,2)'自定义公式-按ALT+F11-插入-模块-粘贴代码-将表格另存为启用宏的格式 Function 多项查询(a As Range, b As Range, c As String, Optional ByVal fgf As String = "|", Optional ByVal 模式 As String = 1)If a.Cells(3, 1) <> "" Then ...
excel表格使用哪个函数统计物品的个数答:你在I4单元格中输入,=countif(F4:G4,“>886”),在J4单元格中输入,=countif(F4:G4,“<883”),在k4单元格中输入,=SUM(F4:G4),然后三个同时下拉,偏大的总和公式是=SUMIF(A4:A1000,"a",I4:I1000),偏小的=SUMIF(A4:A1000,"a",J4:J1000),不在877-833之间也就总和=SUMIF(A4:...