| 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
|
| Calc macro display |
|---|
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 |
| Calc macro display |
|---|
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 |
| Calc macro display |
|---|
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 |
| Calc macro display |
|---|
(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 |
| Calc macro display |
|---|
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") |
| Calc macro display |
|---|
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 Oops → fixed |
|---|