{"id":852,"date":"2022-12-04T01:03:33","date_gmt":"2022-12-04T01:03:33","guid":{"rendered":"https:\/\/s-oneill.com\/sov02\/?p=852"},"modified":"2022-12-04T01:33:40","modified_gmt":"2022-12-04T01:33:40","slug":"spreadsheets","status":"publish","type":"post","link":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/","title":{"rendered":"Spreadsheets"},"content":{"rendered":"<p><strong>Excel (and Google Sheets)<\/strong><br \/>\nThis area will discuss popular functions used in both Excel and Google Sheets and provide examples of charts, pivot tables and other useful spreadsheet features. <\/p>\n<ul>\n<li>COUNT<\/li>\n<li>COUNTIF\n<li>SUM<\/li>\n<li>SUMIF<\/li>\n<li>MIN<\/li>\n<li>MAX<\/li>\n<li>MAXIF<\/li>\n<li>AVERAGE<\/li>\n<li>AVERAGEIF<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel (and Google Sheets) This area will discuss popular functions used in both Excel and Google Sheets and provide examples of charts, pivot tables and other useful spreadsheet features. COUNT COUNTIF SUM SUMIF MIN MAX MAXIF AVERAGE AVERAGEIF<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-852","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Spreadsheets - s-oneill.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Spreadsheets - s-oneill.com\" \/>\n<meta property=\"og:description\" content=\"Excel (and Google Sheets) This area will discuss popular functions used in both Excel and Google Sheets and provide examples of charts, pivot tables and other useful spreadsheet features. COUNT COUNTIF SUM SUMIF MIN MAX MAXIF AVERAGE AVERAGEIF\" \/>\n<meta property=\"og:url\" content=\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"s-oneill.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-04T01:03:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-04T01:33:40+00:00\" \/>\n<meta name=\"author\" content=\"Me(sean)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Me(sean)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/\"},\"author\":{\"name\":\"Me(sean)\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/ab11148c6ea273be80dddd8baec1a545\"},\"headline\":\"Spreadsheets\",\"datePublished\":\"2022-12-04T01:03:33+00:00\",\"dateModified\":\"2022-12-04T01:33:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/\"},\"wordCount\":39,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/\",\"url\":\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/\",\"name\":\"Spreadsheets - s-oneill.com\",\"isPartOf\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/#website\"},\"datePublished\":\"2022-12-04T01:03:33+00:00\",\"dateModified\":\"2022-12-04T01:33:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/spreadsheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/s-oneill.com\/sov02\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Spreadsheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/#website\",\"url\":\"https:\/\/s-oneill.com\/sov02\/\",\"name\":\"s-oneill.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/s-oneill.com\/sov02\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a\",\"name\":\"sean o\",\"logo\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/image\/\"},\"description\":\"Web dev over 15 years.\",\"sameAs\":[\"http:\/\/s-oneill.com\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/ab11148c6ea273be80dddd8baec1a545\",\"name\":\"Me(sean)\",\"url\":\"https:\/\/s-oneill.com\/sov02\/author\/user01\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Spreadsheets - s-oneill.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/","og_locale":"en_US","og_type":"article","og_title":"Spreadsheets - s-oneill.com","og_description":"Excel (and Google Sheets) This area will discuss popular functions used in both Excel and Google Sheets and provide examples of charts, pivot tables and other useful spreadsheet features. COUNT COUNTIF SUM SUMIF MIN MAX MAXIF AVERAGE AVERAGEIF","og_url":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/","og_site_name":"s-oneill.com","article_published_time":"2022-12-04T01:03:33+00:00","article_modified_time":"2022-12-04T01:33:40+00:00","author":"Me(sean)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Me(sean)","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/#article","isPartOf":{"@id":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/"},"author":{"name":"Me(sean)","@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/ab11148c6ea273be80dddd8baec1a545"},"headline":"Spreadsheets","datePublished":"2022-12-04T01:03:33+00:00","dateModified":"2022-12-04T01:33:40+00:00","mainEntityOfPage":{"@id":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/"},"wordCount":39,"commentCount":0,"publisher":{"@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/s-oneill.com\/sov02\/spreadsheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/","url":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/","name":"Spreadsheets - s-oneill.com","isPartOf":{"@id":"https:\/\/s-oneill.com\/sov02\/#website"},"datePublished":"2022-12-04T01:03:33+00:00","dateModified":"2022-12-04T01:33:40+00:00","breadcrumb":{"@id":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/s-oneill.com\/sov02\/spreadsheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/s-oneill.com\/sov02\/spreadsheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/s-oneill.com\/sov02\/"},{"@type":"ListItem","position":2,"name":"Spreadsheets"}]},{"@type":"WebSite","@id":"https:\/\/s-oneill.com\/sov02\/#website","url":"https:\/\/s-oneill.com\/sov02\/","name":"s-oneill.com","description":"","publisher":{"@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/s-oneill.com\/sov02\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a","name":"sean o","logo":{"@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/image\/"},"description":"Web dev over 15 years.","sameAs":["http:\/\/s-oneill.com"]},{"@type":"Person","@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/ab11148c6ea273be80dddd8baec1a545","name":"Me(sean)","url":"https:\/\/s-oneill.com\/sov02\/author\/user01\/"}]}},"_links":{"self":[{"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/posts\/852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/comments?post=852"}],"version-history":[{"count":3,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/posts\/852\/revisions"}],"predecessor-version":[{"id":863,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/posts\/852\/revisions\/863"}],"wp:attachment":[{"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/media?parent=852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/categories?post=852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/tags?post=852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}