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 12 Current »


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

(thumbs up)

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

(thumbs up)

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) bug! → (tick) 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

(error) bug! → (tick) fixed

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

(error) Oops → (tick) fixed