Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current Restore this Version View Page History

« Previous Version 10 Next »


Primary CategorySecondary CategoryQty
1PC1SC11
2PC2SC12
3PC1SC23
4PC1SC34
5PC2SC35
6

sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC1") + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC2") * 2

(tick)

sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC2") * 2 + sumifs(c1:c5, a1:a5, "PC1", B1:B5, "SC3") * 3

(tick)

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

(error)

(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

(error)

sum(c1:c5) + sum(c1:c5) * 2 + sum(c1:c5) * 3

(tick)

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