Tips.GoogleSheets.md

Google Sheet Tips

Documentation

• https://support.google.com/docs/topic/9054603?hl=en&ref_topic=1382883

Documentation: Functions

• Function List

• Reference data from other sheets

  • Examples
    • =Sheet1!A1 or ='Sheet number two'!B4.

• COUNTIF

  • Examples:
    • COUNTIF(A1:A10,">20")
    • COUNTIF(A1:A10,"Paid")