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 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
  • No labels