| 楼主 罗刚君 |
Q:Sumifs与SumProduct都可以实现多条件求和,哪个更快呢? A:Sumifs 10000行数据 双条件求和,分别用Sumifs与SumProduct实现求和,速度差异近三倍 Sumifs快过SumProduct Sub one() Dim t As Date, t2 As Date, a As Double t = Timer For i = 1 To 1000 a = [=SUMIFS(C1:C10000,A1:A10000,"A",B1:B10000,"乙")] Next t2 = Timer MsgBox Format(t2 - t, "0.00秒") End Sub Sub two() Dim t As Date, t2 As Date, a As Double t = Timer For i = 1 To 1000 b = [=SUMPRODUCT((A1:A10000="A")*(B1:B10000="乙")*C1:C10000)] Next t2 = Timer MsgBox Format(t2 - t, "0.00秒") End Sub  多条件求和 速度比拼.rar |
| 2楼 764360615 |
 一楼沙发用来灌水.... |
| 3楼 天南地北 |
罗版，字写错了 QQ截图未命名.jpg |
| 4楼 悠悠雨 |
意思理解 |
| 5楼 李海宾 |
 跟帖学习 |
| 6楼 传递 |
天南地北好仔细 |
| 7楼 罗刚君 |
条件越多,SUMIFS的优势越明显 所以SUMPRODUCT多条件汇总尽量少用 但是SUMPRODUCT也有它不可取代之处,就是条件为内存数组时没法用SUMIFS执行,SUMIFS只支持区域引用 |
| 8楼 NULL |
学习 |