Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Skip to search results
Create a formula
Learn techniques for unleashing the power of formulas. Start with basics and work your way up. Learn ways to minimize complexity.
Create an external reference (link) to a cell range in another workbook
You can refer to the contents of cells in another workbook by creating an external reference. An external reference (also called a link) is a reference to a cel...
Guidelines and examples of array formulas
Show All Hide All To become an Excel power user, you need to know how to use array formulas, which can perform calculations that you can't do by using non-array...
Overview of formulas
Learn how Excel formulas work. Troubleshoot common formula problems. Find links to specific help on functions.
XL: Some Worksheet Functions Do Not Allow Array Constants
XL2000: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
XL2000: SUMIF and COUNTIF Functions Return Incorrect Results When Used with Strings Longer Than 255 Characters
XL2000: SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error
XL2002: AutoSum Button Unexpectedly Returns Values from Hidden Cells in List with AutoFilter