[fixed] Bugs for formula contains 3 (or more) SumIfs functions
| Primary Category | Secondary Category | Qty | |
|---|---|---|---|
| 1 | PC1 | SC1 | 1 |
| 2 | PC2 | SC1 | 2 |
| 3 | PC1 | SC2 | 3 |
| 4 | PC1 | SC3 | 4 |
| 5 | PC2 | SC3 | 5 |
| 6 | sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC1") + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC2") * 2 |
|  |
| sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC2") * 2 + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC3") * 3 |
| | |
| sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC1") + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC2") * 2 + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC3") * 3 |
|  bug! →  fixed | |
| (sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC1") + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC2") * 2 ) + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC3") * 3 |
| bug! → fixed | |
| sum(c1:c5) + sum(c1:c5) * 2 + sum(c1:c5) * 3 |
|
Parsing operators is not the cause. | |
| sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC1") + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC2") + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC3") |
| Oops → fixed |