{"id":568,"date":"2014-10-05T15:14:47","date_gmt":"2014-10-05T13:14:47","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=568"},"modified":"2024-05-25T19:57:54","modified_gmt":"2024-05-25T17:57:54","slug":"status-bar-metrics","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/status-bar-metrics\/","title":{"rendered":"Status Bar Metrics"},"content":{"rendered":"<p>When you select a range of cells you can quickly see key metrics like the <em>Sum, Count, Minimum, Maxi mun and Average.<\/em><\/p>\n<p>To activate this you will need to Right Click on the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-status-bar-not-showing-sum\/\" target=\"_blank\" rel=\"noopener\">Status Bar<\/a> at the bottom of your workbook and choose the metrics that you want to show.\u00a0 Once selected, these option remain saved for all future workbooks.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/ge9ROeDjh6E?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Metrics-on-Status-Bar.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Metrics-on-Status-Bar.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> <strong>Right click anywhere on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/status-bar-in-excel\/\" target=\"_blank\" rel=\"noopener\">the Status Bar<\/a><\/strong> to show the customization menu<br \/>\n<img loading=\"lazy\" decoding=\"async\" title=\"Status Bar Metrics\" class=\"alignnone size-full wp-image-20070\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-01-1.jpg\" alt=\"Status Bar Metrics\" width=\"1049\" height=\"724\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-01-1.jpg 1049w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-01-1-300x207.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-01-1-1024x707.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-01-1-768x530.jpg 768w\" sizes=\"(max-width: 1049px) 100vw, 1049px\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Tick the values that you want to be displayed in your Status Bar<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Status Bar Metrics\" class=\"alignnone size-full wp-image-20067\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-02.jpg\" alt=\"Status Bar Metrics\" width=\"356\" height=\"715\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-02.jpg 356w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-02-149x300.jpg 149w\" sizes=\"(max-width: 356px) 100vw, 356px\" \/><\/p>\n<p>Now when you select and highlight numerical values, these auto-computed metrics will now show up in your status bar!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Status Bar Metrics\" class=\"alignnone size-full wp-image-20068\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-03.jpg\" alt=\"Status Bar Metrics\" width=\"1147\" height=\"435\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-03.jpg 1147w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-03-300x114.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-03-1024x388.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/status-bar-03-768x291.jpg 768w\" sizes=\"(max-width: 1147px) 100vw, 1147px\" \/><\/p>\n<p><span style=\"color: #0000ff\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-722 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/728x901-e1413496235820.gif\" alt=\"728x90\" width=\"599\" height=\"74\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you select a range of cells you can quickly see key metrics like the Sum, Count, Minimum, Maxi mun and Average. To activate this you will need to Right Click on the Status Bar at the bottom of your workbook and choose the metrics that you want to show.\u00a0 Once selected, these option remain [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17721,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Status Bar Metrics","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[7,10],"tags":[62],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/568"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=568"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/568\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17721"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}