Excel 2010 Bible

Chapter 13: Creating Formulas That Count and Sum 299 Cross-Reference I cover pivot tables in detail in Chapters 34 and 35, and y ...

Part II: Working with Formulas and Functions 300 You can use complete rows or columns as an argument for the SUM function. The f ...

Chapter 13: Creating Formulas That Count and Sum 301 range argument adjusts such that the sum always starts with row 2 and ends ...

Part II: Working with Formulas and Functions 302 On the CD This workbook is available on the companion CD-ROM. The file is named ...

Chapter 13: Creating Formulas That Count and Sum 303 Cross-Reference See Chapter 16 for more information about using array const ...

Part II: Working with Formulas and Functions 304 Summing only negative values .................................................. ...

Chapter 13: Creating Formulas That Count and Sum 305 Summing values based on a date comparison ................................. ...

Part II: Working with Formulas and Functions 306 FIGURE 13.15 This worksheet demonstrates summing based on multiple criteria. Us ...

Chapter 13: Creating Formulas That Count and Sum 307 Using And and Or criteria ................................................. ...

...

309 CHAPTER Creating Formulas That Look Up Values IN THIS CHAPTER An introduction to formulas that look up values in a table An ...

Part II: Working with Formulas and Functions 310 The following lookup formulas use the VLOOKUP function: D2 =VLOOKUP(C2,EmpData, ...

Chapter 14: Creating Formulas That Look Up Values 311 TABLE 14.1 Functions Used in Lookup Formulas Function Description CHOOSE R ...

Part II: Working with Formulas and Functions 312 Basic Lookup Formulas ......................................................... ...

Chapter 14: Creating Formulas That Look Up Values 313 Tip If the lookup_value argument is text and the range_lookup argument is ...

Part II: Working with Formulas and Functions 314 The syntax for the HLOOKUP function is HLOOKUP(lookup_value,table_array,row_ind ...

Chapter 14: Creating Formulas That Look Up Values 315 The function’s arguments are as follows: l lookup_value: The value to be l ...

Part II: Working with Formulas and Functions 316 Combining the MATCH and INDEX functions ....................................... ...

Chapter 14: Creating Formulas That Look Up Values 317 FIGURE 14.5 Using the INDEX and MATCH functions to perform a lookup. The E ...

Part II: Working with Formulas and Functions 318 Specialized Lookup Formulas ................................................... ...