| 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, "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, "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 |
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 |
(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 |
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") |
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 |
---|