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

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.