Versions Compared

Old Version 8

changes.mady.by.user Anonymous

Saved on

compared with

New Version 9

changes.mady.by.user K A

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


categoryvalueformulaSUMIF
cat12sumif(A1:A5, "cat1", B1:B5) = 


Calc macro display
sumif(A1:A5, "cat1", B1:B5)


cat134sumif(B1:B5, ">5") = 


Calc macro display
sumif(B1:B5, ">5")


cat16


Calc macro display
sum(B1:B3)


cat28

cat110