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 |
| ||
(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 |
| ||
1 + 2 + 3 |
|
Manage space
Manage content
Integrations
Add Comment