Skip to content

Instantly share code, notes, and snippets.

@nd3w

nd3w/LibreOfficeCalcFormulasAndTips.md

Last active June 14, 2023 12:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nd3w/54c1fb7fbf9f6bbc84bdb3247c513c73 to your computer and use it in GitHub Desktop.
Save nd3w/54c1fb7fbf9f6bbc84bdb3247c513c73 to your computer and use it in GitHub Desktop.
Download ZIP
LibreOffice Calc Formulas and Tips
Raw
LibreOfficeCalcFormulasAndTips.md

Calculate average value from B2 to B32 with B24 to B32 are blanks:

=SUM(B2:B32)/(ROWS(B2:B32)-COUNTBLANK(B2:B32))

or simply:

=AVERAGE(B2:B32)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment