{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-26T07:12:54+00:00","modifiedTime":"2018-09-19T01:30:33+00:00","timestamp":"2022-09-14T18:16:47+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"Excel Functions You're Likely to Use","strippedTitle":"excel functions you're likely to use","slug":"excel-functions-youre-likely-to-use","canonicalUrl":"","seo":{"metaDescription":"Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used b","noIndex":0,"noFollow":0},"content":"Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference to the purpose of each Excel function.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<th>Excel Function</th>\r\n<th>Description</th>\r\n</tr>\r\n<tr>\r\n<td>SUM</td>\r\n<td>Calculates the sum of a group of values</td>\r\n</tr>\r\n<tr>\r\n<td>AVERAGE</td>\r\n<td>Calculates the mean of a group of values</td>\r\n</tr>\r\n<tr>\r\n<td>COUNT</td>\r\n<td>Counts the number of cells in a range that contains\r\nnumbers</td>\r\n</tr>\r\n<tr>\r\n<td>INT</td>\r\n<td>Removes the decimal portion of a number, leaving just the\r\ninteger portion</td>\r\n</tr>\r\n<tr>\r\n<td>ROUND</td>\r\n<td>Rounds a number to a specified number of decimal places or\r\ndigit positions</td>\r\n</tr>\r\n<tr>\r\n<td>IF</td>\r\n<td>Tests for a true or false condition and then returns one value\r\nor another</td>\r\n</tr>\r\n<tr>\r\n<td>NOW</td>\r\n<td>Returns the system date and time</td>\r\n</tr>\r\n<tr>\r\n<td>TODAY</td>\r\n<td>Returns the system date, without the time</td>\r\n</tr>\r\n<tr>\r\n<td>SUMIF</td>\r\n<td>Calculates a sum from a group of values, but just of values\r\nthat are included because a condition is met</td>\r\n</tr>\r\n<tr>\r\n<td>COUNTIF</td>\r\n<td>Counts the number of cells in a range that match a\r\ncriteria</td>\r\n</tr>\r\n</tbody>\r\n</table>","description":"Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference to the purpose of each Excel function.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<th>Excel Function</th>\r\n<th>Description</th>\r\n</tr>\r\n<tr>\r\n<td>SUM</td>\r\n<td>Calculates the sum of a group of values</td>\r\n</tr>\r\n<tr>\r\n<td>AVERAGE</td>\r\n<td>Calculates the mean of a group of values</td>\r\n</tr>\r\n<tr>\r\n<td>COUNT</td>\r\n<td>Counts the number of cells in a range that contains\r\nnumbers</td>\r\n</tr>\r\n<tr>\r\n<td>INT</td>\r\n<td>Removes the decimal portion of a number, leaving just the\r\ninteger portion</td>\r\n</tr>\r\n<tr>\r\n<td>ROUND</td>\r\n<td>Rounds a number to a specified number of decimal places or\r\ndigit positions</td>\r\n</tr>\r\n<tr>\r\n<td>IF</td>\r\n<td>Tests for a true or false condition and then returns one value\r\nor another</td>\r\n</tr>\r\n<tr>\r\n<td>NOW</td>\r\n<td>Returns the system date and time</td>\r\n</tr>\r\n<tr>\r\n<td>TODAY</td>\r\n<td>Returns the system date, without the time</td>\r\n</tr>\r\n<tr>\r\n<td>SUMIF</td>\r\n<td>Calculates a sum from a group of values, but just of values\r\nthat are included because a condition is met</td>\r\n</tr>\r\n<tr>\r\n<td>COUNTIF</td>\r\n<td>Counts the number of cells in a range that match a\r\ncriteria</td>\r\n</tr>\r\n</tbody>\r\n</table>","blurb":"","authors":[{"authorId":8996,"name":"Ken Bluttman","slug":"ken-bluttman","description":" <p><b>Ken Bluttman</b> is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written articles and books on topics like Office/VBA development, XML, SQL Server, and InfoPath. Ken is the author of <i>Excel Charts For Dummies</i> and all previous editions of <i>Excel Formulas & Functions For Dummies.</i> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8996"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":259906,"title":"How to Use Excel’s OFFSET Function","slug":"how-to-use-excels-offset-function","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259906"}},{"articleId":259900,"title":"How to Use Excel’s ADDRESS Function","slug":"how-to-use-excels-address-function","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259900"}},{"articleId":259894,"title":"Using the Excel IF Function: Testing on One Condition","slug":"using-the-excel-if-function-testing-on-one-condition","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259894"}},{"articleId":259887,"title":"How to Convert a Date from Text with Excel’s DATEVALUE Function","slug":"how-to-convert-a-date-from-text-with-excels-datevalue-function","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259887"}},{"articleId":259797,"title":"How to Use Excel’s FORECAST Function","slug":"how-to-use-excels-forecast-function","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259797"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281712,"slug":"excel-formulas-functions-for-dummies","isbn":"9781119839118","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/1119839114/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119839114/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119839114-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119839114/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119839114/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119839118-203x255.jpg","width":203,"height":255},"title":"Excel Formulas & Functions For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"<p><p><b><b data-author-id=\"8996\">Ken Bluttman</b></b> is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written articles and books on topics like Office/VBA development, XML, SQL Server, and InfoPath. Ken is the author of <i>Excel Charts For Dummies</i> and all previous editions of <i>Excel Formulas & Functions For Dummies.</i></p>","authors":[{"authorId":8996,"name":"Ken Bluttman","slug":"ken-bluttman","description":" <p><b>Ken Bluttman</b> is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written articles and books on topics like Office/VBA development, XML, SQL Server, and InfoPath. Ken is the author of <i>Excel Charts For Dummies</i> and all previous editions of <i>Excel Formulas & Functions For Dummies.</i> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/8996"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119839118"]}]\" id=\"du-slot-63221a8f0eca3\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119839118"]}]\" id=\"du-slot-63221a8f0f4fb\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":139080},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-03-04T05:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/excel/excel-functions-youre-likely-to-use-139080/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"excel-functions-youre-likely-to-use-139080"},"fullPath":"/article/technology/software/microsoft-products/excel/excel-functions-youre-likely-to-use-139080/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

Excel Functions You're Likely to Use

By: Ken Bluttman and

Updated: 09-19-2018

From The Book: Excel Formulas & Functions For Dummies

Excel Formulas & Functions For Dummies

Explore Book Buy On Amazon

Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference to the purpose of each Excel function.

Excel Function	Description
SUM	Calculates the sum of a group of values
AVERAGE	Calculates the mean of a group of values
COUNT	Counts the number of cells in a range that contains numbers
INT	Removes the decimal portion of a number, leaving just the integer portion
ROUND	Rounds a number to a specified number of decimal places or digit positions
IF	Tests for a true or false condition and then returns one value or another
NOW	Returns the system date and time
TODAY	Returns the system date, without the time
SUMIF	Calculates a sum from a group of values, but just of values that are included because a condition is met
COUNTIF	Counts the number of cells in a range that match a criteria

About This Article

This article is from the book:

Excel Formulas & Functions For Dummies ,

About the book author:

Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written articles and books on topics like Office/VBA development, XML, SQL Server, and InfoPath. Ken is the author of Excel Charts For Dummies and all previous editions of Excel Formulas & Functions For Dummies.

This article can be found in the category:

Excel ,

Article Categories

Book Categories

Collections