{"id":467,"date":"2026-04-08T03:02:09","date_gmt":"2026-04-07T18:02:09","guid":{"rendered":"https:\/\/tablenote.webdia.net\/?page_id=467"},"modified":"2026-04-08T03:02:09","modified_gmt":"2026-04-07T18:02:09","slug":"supported-functions","status":"publish","type":"page","link":"https:\/\/tablenote.webdia.net\/en\/supported-functions\/","title":{"rendered":"Supported Functions"},"content":{"rendered":"\n

This page explains the functions available in sheets and their basic usage.<\/p>\n\n\n\n

\n\n\n\n


Available Functions<\/strong><\/strong><\/h2>\n\n\n\n
    \n
  • SUM<\/li>\n\n\n\n
  • AVERAGE<\/li>\n\n\n\n
  • MIN<\/li>\n\n\n\n
  • MAX<\/li>\n\n\n\n
  • COUNT<\/li>\n\n\n\n
  • ROUND<\/li>\n\n\n\n
  • <\/li>\n<\/ul>\n\n\n\n
    \n\n\n\n

    How to Use Each Function<\/strong><\/strong><\/h2>\n\n\n\n

    SUM<\/strong><\/p>\n\n\n\n

    Returns the total of the specified values or range.<\/p>\n\n\n\n

    Example:\u00a0=SUM(A1:A10)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    AVERAGE<\/strong><\/p>\n\n\n\n

    Returns the average of the specified values or range.<\/p>\n\n\n\n

    Example:\u00a0=AVERAGE(A1:A10)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    MIN<\/strong><\/p>\n\n\n\n

    Returns the minimum value in the specified values or range.<\/p>\n\n\n\n

    Example:\u00a0=MIN(A1:A10)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    MAX<\/strong><\/p>\n\n\n\n

    Returns the maximum value in the specified values or range.<\/p>\n\n\n\n

    Example:\u00a0=MAX(A1:A10)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    COUNT<\/strong><\/p>\n\n\n\n

    Returns the number of numeric values in the specified values or range.<\/p>\n\n\n\n

    Example:\u00a0=COUNT(A1:A10)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    ROUND<\/strong><\/p>\n\n\n\n

    Rounds a value to the specified number of decimal places.<\/p>\n\n\n\n

    Example:\u00a0=ROUND(A1,2)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    \n\n\n\n

    Notes<\/strong><\/strong><\/h2>\n\n\n\n

    \u2022 Functions must always begin with\u00a0=.<\/p>\n\n\n\n

    \u2022 Use\u00a0:\u00a0to specify a range, such as\u00a0A1:B10.<\/p>\n\n\n\n

    \u2022 If the input is invalid, the result will be displayed as\u00a0Error.<\/p>\n\n\n\n

    \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

    This page explains the functions available in sheets and their basic usage. Available Functions How to Use Each Function SUM Returns the total of the specified values or range. Example:\u00a0=SUM(A1:A10) AVERAGE Returns the average of the specified values or range. Example:\u00a0=AVERAGE(A1:A10) MIN Returns the minimum value in the specified values or range. Example:\u00a0=MIN(A1:A10) MAX Returns […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_locale":"en_US","_original_post":"https:\/\/tablenote.webdia.net\/?page_id=322","footnotes":""},"class_list":["post-467","page","type-page","status-publish","hentry","en-US"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/comments?post=467"}],"version-history":[{"count":0,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/467\/revisions"}],"wp:attachment":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/media?parent=467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}