The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. This article is an excerpt from Excel Gurus Gone Wild. Summary: When you use a space between arguments in a SUM function, Excel returns only the intersection of the ranges. Excel creates five named ranges in this selection. Only one cell is in common between these two ranges, so the result is the 88,351 found in cell C3. The formula =SUM (Boston COGS) finds the one cell at the intersection of the Boston range (B3:F3) and the COGS range (C2:C13). However, if you include a space between the named ranges, Excel includes only the cells at the intersection of the two ranges. You can now easily sum a range by using =SUM(Sales) or =SUM(Atlanta,Charlotte). For example, the GP range refers to D2:D13. ExcelĪlso creates five range names for the headings in row 1. For example, the name Louisville applies to cells B13:F13. Excel creates names for the 12 cities in column A.
As discussed in “Quickly Create Many Range Names” on page 76, you can add range names by using these steps:
Say that you have the worksheet shown in Figure 40. However, very few people understand that the space character is actually an intersection operator when used in a SUM function! Most people realize that =SUM(A1,A3,A5,A7,A9) adds up the five cells specified. Everyone knows that =SUM(A2:A10) sums the nine-cell range from A2 through A10. Solution: To solve this problem, you can use the intersection character in your SUM function. The table nomenclature in Excel 2007 isn’t as easy to use. Challenge: Excel 2003 offers relatively obscure natural language formulas, but they were removed from Excel 2007.
0 kommentar(er)
