vti_encoding:SR|utf8-nl vti_timelastmodified:TR|01 May 2016 22:12:28 -0000 vti_extenderversion:SR|6.0.2.8161 vti_backlinkinfo:VX|Links/thankyou.htm 0TopNav.htm Excel/excel-formulas.htm 0TopNav.031230.htm Excel/data-tables.htm vti_author:SR|Dave-PC\\Dave vti_modifiedby:SR|mainpc\\raina vti_timecreated:TR|12 Nov 2008 07:55:19 -0000 vti_title:SR|Excel Formulas/Formulae. Microsoft Excel Formulas (Formulae) & Tips/Tricks vti_nexttolasttimemodified:TR|02 May 2016 11:12:06 -0000 vti_cacheddtm:TX|01 May 2016 22:12:28 -0000 vti_filesize:IR|34691 vti_cachedtitle:SR|Excel Formulas/Formulae. Microsoft Excel Formulas (Formulae) & Tips/Tricks vti_cachedbodystyle:SR| vti_cachedlinkinfo:VX|Q|http://www.ozgrid.com/css/ozgrid.css S|http://www.ozgrid.com/SideNavJS/stmenu.js H|http://www.excel-easy.com/introduction/formulas-functions.html H|http://www.exceluser.com/cmd.php H|http://www.ozgrid.com/ S|http://www.ozgrid.com/images/logo/ozgrid.gif S|http://pagead2.googlesyndication.com/pagead/show_ads.js H|http://www.regnow.com/softsell/visitor.cgi H|http://www.regnow.com/softsell/visitor.cgi H|http://www.ozgrid.com/Services/Excel-Web-Java.htm S|http://www.ozgrid.com/images/Pictures/Excel-icon.png H|http://www.ozgrid.com/Excel/Sum.htm H|http://www.ozgrid.com/Excel/autosum.htm H|http://www.ozgrid.com/Excel/arrays.htm H|sum-wizard.htm H|http://www.ozgrid.com/Excel/sum-if.htm H|http://www.ozgrid.com/Excel/sum-every-2nd-nth-cell.htm H|http://www.ozgrid.com/Excel/excel-sum-top-bottom-x.htm H|http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm H|increase-percent.htm H|http://www.ozgrid.com/Excel/subtotal.htm H|http://www.ozgrid.com/Excel/excel-bold-subtotals.htm H|http://www.ozgrid.com/Excel/excel-subtotal-function.htm H|http://www.ozgrid.com/Excel/data-tables.htm H|sum-between-dates.htm H|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm H|http://www.ozgrid.com/Excel/count-if.htm H|http://www.ozgrid.com/Excel/excel-count-one-occurrence.htm H|http://www.ozgrid.com/Excel/count-words.htm H|http://www.ozgrid.com/Excel/count-list.htm H|count-between-dates.htm H|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm H|http://www.ozgrid.com/Excel/excel-vlookup-formula.htm H|stop-na-vlookup.htm H|http://www.ozgrid.com/Excel/excel-hlookup-formula.htm H|http://www.ozgrid.com/Excel/left-lookup.htm H|lookup-array-constant.htm H|dynamic-formulas.htm H|http://www.ozgrid.com/Excel/left-lookup.htm H|index-match.htm H|excel-vlookup-formula.htm H|http://www.ozgrid.com/Excel/find-nth.htm H|lookup-table.htm H|dynamic-lookups.htm H|http://www.ozgrid.com/Excel/cell-lookup.htm H|hyperlinks.htm H|http://www.ozgrid.com/Excel/hyperlink-lookup.htm H|http://www.ozgrid.com/Excel/excel-vlookup-formula.htm H|http://www.ozgrid.com/Excel/left-lookup.htm H|http://www.ozgrid.com/Excel/excel-hlookup-formula.htm H|report.htm H|multi-table-lookup.htm H|dependent-lists.htm H|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm H|seven-nested.htm H|nested-function-limit.htm H|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm H|http://www.ozgrid.com/Excel/excel-rounding.htm H|http://www.ozgrid.com/Excel/percentages.htm H|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm H|average-without-zero.htm H|minimum-without-zero.htm H|excel-quick-tips.htm H|http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm H|http://www.ozgrid.com/Excel/TipsAndTricks.htm H|http://www.ozgrid.com/Excel/Formulas.htm H|http://www.ozgrid.com/Excel/TextFormulas.htm H|nifty-formulas.htm H|http://www.ozgrid.com/search/excel.htm H|http://www.ozgrid.com/forum/ H|formula-errors.htm H|http://www.ozgrid.com/News/Archive.htm H|debug-formula-errors.htm H|free-training/basic-index.htm H|../Services/ExternalFree.htm H|http://www.ozgrid.com/forum/forumdisplay.php H|http://www.ozgrid.com/forum/ H|http://www.ozgrid.com/Excel/excel-faq.htm H|http://www.ozgrid.com/search/excel.htm H|http://www.ozgrid.com/Excel/excel-charts.htm H|http://www.ozgrid.com/Excel/ChartTips.htm H|http://www.ozgrid.com/search/excel.htm H|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm H|../Excel/sliding-bracket.htm H|fixed-rate-lookup.htm H|http://www.ozgrid.com/Excel/excel-vlookup-formula.htm H|http://www.ozgrid.com/Excel/excel-pivot-tables.htm H|http://www.ozgrid.com/Excel/PivotTables/ExCreatePiv1.htm H|http://www.ozgrid.com/Excel/grouping-pivot-tables.htm H|pivot-calculated-fields.htm H|http://www.ozgrid.com/Excel/grouping-pivot-tables.htm H|http://www.ozgrid.com/search/excel.htm H|excel-formulas.htm H|http://office.microsoft.com/en-us/excel/CH100947761033.aspx H|http://office.microsoft.com/en-us/excel/CH100648251033.aspx H|http://office.microsoft.com/en-us/excel/CH101020751033.aspx H|http://office.microsoft.com/en-us/excel/CH100648311033.aspx H|http://office.microsoft.com/en-us/excel/CH100648161033.aspx H|http://office.microsoft.com/en-us/excel/CH101030611033.aspx H|http://office.microsoft.com/en-us/excel/CH100648261033.aspx H|http://office.microsoft.com/en-us/excel/CH100648181033.aspx H|http://office.microsoft.com/en-us/excel/CH100740791033.aspx H|http://office.microsoft.com/en-us/excel/CH100648211033.aspx H|http://office.microsoft.com/en-us/excel/CH100648071033.aspx H|http://office.microsoft.com/en-us/excel/CH100648451033.aspx H|http://office.microsoft.com/en-us/excel/CH102509001033.aspx H|http://office.microsoft.com/en-us/excel/CH100645001033.aspx H|http://office.microsoft.com/en-us/excel/CH100645021033.aspx H|http://office.microsoft.com/en-us/excel/CH100648241033.aspx H|http://office.microsoft.com/en-us/excel/CH102244451033.aspx H|http://office.microsoft.com/en-us/excel/CH100648471033.aspx H|http://office.microsoft.com/en-us/excel/CH101637611033.aspx H|http://office.microsoft.com/en-us/excel/CH101001571033.aspx H|http://office.microsoft.com/en-us/excel/CH100648481033.aspx H|http://office.microsoft.com/en-us/excel/CH101024611033.aspx H|http://office.microsoft.com/en-us/excel/CH100743441033.aspx H|http://office.microsoft.com/en-us/excel/CH100648271033.aspx H|http://office.microsoft.com/en-us/excel/CH100648291033.aspx H|http://office.microsoft.com/en-us/excel/CH100648541033.aspx H|http://office.microsoft.com/en-us/excel/CH102248301033.aspx H|http://office.microsoft.com/en-us/excel/CH100648501033.aspx H|http://office.microsoft.com/en-us/excel/CH100648511033.aspx H|http://office.microsoft.com/en-us/excel/CH101030621033.aspx H|http://office.microsoft.com/en-us/excel/CH100648081033.aspx H|http://office.microsoft.com/en-us/excel/CH100648301033.aspx H|http://office.microsoft.com/en-us/excel/CH101020791033.aspx H|http://office.microsoft.com/en-us/excel/CH102094651033.aspx H|http://office.microsoft.com/en-us/excel/CH100648521033.aspx H|http://office.microsoft.com/en-us/excel/CH100648131033.aspx H|http://office.microsoft.com/en-us/excel/CH010004901033.aspx H|http://office.microsoft.com/en-us/excel/CH010036991033.aspx H|http://office.microsoft.com/en-us/excel/CH010037001033.aspx H|http://office.microsoft.com/en-us/excel/CH010037021033.aspx H|http://office.microsoft.com/en-us/excel/CH010004911033.aspx H|http://office.microsoft.com/en-us/excel/CH010005111033.aspx H|http://office.microsoft.com/en-us/excel/CH010005121033.aspx H|http://office.microsoft.com/en-us/excel/CH010005131033.aspx H|http://office.microsoft.com/en-us/excel/CH010004911033.aspx H|http://office.microsoft.com/en-us/excel/CH010004921033.aspx H|http://office.microsoft.com/en-us/excel/CH010004931033.aspx H|http://office.microsoft.com/en-us/excel/CH010004941033.aspx H|http://office.microsoft.com/en-us/excel/CH010004951033.aspx H|http://office.microsoft.com/en-us/excel/HP052042111033.aspx H|../all-feeds.htm H|2007-overview.htm H|2007-conditional-formatting.htm H|array-functions.htm H|countif-function.htm H|counting-functions.htm H|database-functions.htm H|date-time-functions.htm H|engineering-functions.htm H|financial-functions.htm H|logical-functions.htm H|lookup-functions.htm H|new-functions.htm H|statisical-functions.htm H|sumifs-functions.htm H|sumproduct-functions.htm H|text-functions.htm H|http://office.microsoft.com/en-us/excel/HA101491511033.aspx H|http://office.microsoft.com/search/redir.aspx H|http://www.ozgrid.com/Training/complete-excel-course.htm H|http://www.ozgrid.com/Services/AddinExamples.htm H|http://www.ozgrid.com/Services/excel-software-categories.htm H|http://www.ozgrid.com/VBA/Functions.htm H|http://www.ozgrid.com/VBA/ H|http://www.ozgrid.com/Services/excel-trade-market.htm A|http://www.ozgrid.com/search/software.htm H|http://fusion.google.com/add S|http://buttons.googlesyndication.com/fusion/add.gif H|http://www.ozgrid.com/search/tips.htm H|http://www.ozgrid.com/forum/ S|http://www.google.com/coop/cse/brand H|http://www.ozgrid.com/free-excel-help.htm vti_cachedsvcrellinks:VX|NQHS|http://www.ozgrid.com/css/ozgrid.css NSHS|http://www.ozgrid.com/SideNavJS/stmenu.js NHHS|http://www.excel-easy.com/introduction/formulas-functions.html NHHS|http://www.exceluser.com/cmd.php NHHS|http://www.ozgrid.com/ NSHS|http://www.ozgrid.com/images/logo/ozgrid.gif NSHS|http://pagead2.googlesyndication.com/pagead/show_ads.js NHHS|http://www.regnow.com/softsell/visitor.cgi NHHS|http://www.regnow.com/softsell/visitor.cgi NHHS|http://www.ozgrid.com/Services/Excel-Web-Java.htm NSHS|http://www.ozgrid.com/images/Pictures/Excel-icon.png NHHS|http://www.ozgrid.com/Excel/Sum.htm NHHS|http://www.ozgrid.com/Excel/autosum.htm NHHS|http://www.ozgrid.com/Excel/arrays.htm FHUS|Excel/sum-wizard.htm NHHS|http://www.ozgrid.com/Excel/sum-if.htm NHHS|http://www.ozgrid.com/Excel/sum-every-2nd-nth-cell.htm NHHS|http://www.ozgrid.com/Excel/excel-sum-top-bottom-x.htm NHHS|http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm FHUS|Excel/increase-percent.htm NHHS|http://www.ozgrid.com/Excel/subtotal.htm NHHS|http://www.ozgrid.com/Excel/excel-bold-subtotals.htm NHHS|http://www.ozgrid.com/Excel/excel-subtotal-function.htm NHHS|http://www.ozgrid.com/Excel/data-tables.htm FHUS|Excel/sum-between-dates.htm NHHS|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm NHHS|http://www.ozgrid.com/Excel/count-if.htm NHHS|http://www.ozgrid.com/Excel/excel-count-one-occurrence.htm NHHS|http://www.ozgrid.com/Excel/count-words.htm NHHS|http://www.ozgrid.com/Excel/count-list.htm FHUS|Excel/count-between-dates.htm NHHS|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm NHHS|http://www.ozgrid.com/Excel/excel-vlookup-formula.htm FHUS|Excel/stop-na-vlookup.htm NHHS|http://www.ozgrid.com/Excel/excel-hlookup-formula.htm NHHS|http://www.ozgrid.com/Excel/left-lookup.htm FHUS|Excel/lookup-array-constant.htm FHUS|Excel/dynamic-formulas.htm NHHS|http://www.ozgrid.com/Excel/left-lookup.htm FHUS|Excel/index-match.htm FHUS|Excel/excel-vlookup-formula.htm NHHS|http://www.ozgrid.com/Excel/find-nth.htm FHUS|Excel/lookup-table.htm FHUS|Excel/dynamic-lookups.htm NHHS|http://www.ozgrid.com/Excel/cell-lookup.htm FHUS|Excel/hyperlinks.htm NHHS|http://www.ozgrid.com/Excel/hyperlink-lookup.htm NHHS|http://www.ozgrid.com/Excel/excel-vlookup-formula.htm NHHS|http://www.ozgrid.com/Excel/left-lookup.htm NHHS|http://www.ozgrid.com/Excel/excel-hlookup-formula.htm FHUS|Excel/report.htm FHUS|Excel/multi-table-lookup.htm FHUS|Excel/dependent-lists.htm NHHS|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm FHUS|Excel/seven-nested.htm FHUS|Excel/nested-function-limit.htm NHHS|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm NHHS|http://www.ozgrid.com/Excel/excel-rounding.htm NHHS|http://www.ozgrid.com/Excel/percentages.htm NHHS|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm FHUS|Excel/average-without-zero.htm FHUS|Excel/minimum-without-zero.htm FHUS|Excel/excel-quick-tips.htm NHHS|http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm NHHS|http://www.ozgrid.com/Excel/TipsAndTricks.htm NHHS|http://www.ozgrid.com/Excel/Formulas.htm NHHS|http://www.ozgrid.com/Excel/TextFormulas.htm FHUS|Excel/nifty-formulas.htm NHHS|http://www.ozgrid.com/search/excel.htm NHHS|http://www.ozgrid.com/forum/ FHUS|Excel/formula-errors.htm NHHS|http://www.ozgrid.com/News/Archive.htm FHUS|Excel/debug-formula-errors.htm FHUS|Excel/free-training/basic-index.htm FHUS|Services/ExternalFree.htm NHHS|http://www.ozgrid.com/forum/forumdisplay.php NHHS|http://www.ozgrid.com/forum/ NHHS|http://www.ozgrid.com/Excel/excel-faq.htm NHHS|http://www.ozgrid.com/search/excel.htm NHHS|http://www.ozgrid.com/Excel/excel-charts.htm NHHS|http://www.ozgrid.com/Excel/ChartTips.htm NHHS|http://www.ozgrid.com/search/excel.htm NHHS|http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm FHUS|Excel/sliding-bracket.htm FHUS|Excel/fixed-rate-lookup.htm NHHS|http://www.ozgrid.com/Excel/excel-vlookup-formula.htm NHHS|http://www.ozgrid.com/Excel/excel-pivot-tables.htm NHHS|http://www.ozgrid.com/Excel/PivotTables/ExCreatePiv1.htm NHHS|http://www.ozgrid.com/Excel/grouping-pivot-tables.htm FHUS|Excel/pivot-calculated-fields.htm NHHS|http://www.ozgrid.com/Excel/grouping-pivot-tables.htm NHHS|http://www.ozgrid.com/search/excel.htm FHUS|Excel/excel-formulas.htm NHHS|http://office.microsoft.com/en-us/excel/CH100947761033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648251033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH101020751033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648311033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648161033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH101030611033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648261033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648181033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100740791033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648211033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648071033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648451033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH102509001033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100645001033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100645021033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648241033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH102244451033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648471033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH101637611033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH101001571033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648481033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH101024611033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100743441033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648271033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648291033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648541033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH102248301033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648501033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648511033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH101030621033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648081033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648301033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH101020791033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH102094651033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648521033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH100648131033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010004901033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010036991033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010037001033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010037021033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010004911033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010005111033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010005121033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010005131033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010004911033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010004921033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010004931033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010004941033.aspx NHHS|http://office.microsoft.com/en-us/excel/CH010004951033.aspx NHHS|http://office.microsoft.com/en-us/excel/HP052042111033.aspx FHUS|all-feeds.htm FHUS|Excel/2007-overview.htm FHUS|Excel/2007-conditional-formatting.htm FHUS|Excel/array-functions.htm FHUS|Excel/countif-function.htm FHUS|Excel/counting-functions.htm FHUS|Excel/database-functions.htm FHUS|Excel/date-time-functions.htm FHUS|Excel/engineering-functions.htm FHUS|Excel/financial-functions.htm FHUS|Excel/logical-functions.htm FHUS|Excel/lookup-functions.htm FHUS|Excel/new-functions.htm FHUS|Excel/statisical-functions.htm FHUS|Excel/sumifs-functions.htm FHUS|Excel/sumproduct-functions.htm FHUS|Excel/text-functions.htm NHHS|http://office.microsoft.com/en-us/excel/HA101491511033.aspx NHHS|http://office.microsoft.com/search/redir.aspx NHHS|http://www.ozgrid.com/Training/complete-excel-course.htm NHHS|http://www.ozgrid.com/Services/AddinExamples.htm NHHS|http://www.ozgrid.com/Services/excel-software-categories.htm NHHS|http://www.ozgrid.com/VBA/Functions.htm NHHS|http://www.ozgrid.com/VBA/ NHHS|http://www.ozgrid.com/Services/excel-trade-market.htm NAHS|http://www.ozgrid.com/search/software.htm NHHS|http://fusion.google.com/add NSHS|http://buttons.googlesyndication.com/fusion/add.gif NHHS|http://www.ozgrid.com/search/tips.htm NHHS|http://www.ozgrid.com/forum/ NSHS|http://www.google.com/coop/cse/brand NHHS|http://www.ozgrid.com/free-excel-help.htm vti_cachedneedsrewrite:BR|false vti_cachedhasbots:BR|false vti_cachedhastheme:BR|false vti_cachedhasborder:BR|false vti_metatags:VR|HTTP-EQUIV=Content-Language en-us description Microsoft\\ \\ Excel\\ Formulas.\\ Learn\\ Microsoft\\ Excel\\ Formulas\\ Free\\ With\\ Ozgrid.\\ Free\\ Excel\\ Formulae\\ Training keywords Excel\\ formulas,Excel\\ Tips,Functions,Excel\\ tips\\ tricks,\\ excel\\ formulas,\\ help vti_charset:SR|windows-1252 vti_language:SR|en-us