• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Formula Annoyances > ARRAY FORMULA ANNOYANCES

ARRAY FORMULA ANNOYANCES

DEPLOY ARRAY FORMULAS

The Annoyance:

I inherited an inventory-tracking workbook (shown in Figure 3-14) from an engineer in my custom computer-building company. Somehow, she created what appears to be a formula that calculates the total value of our inventory by multiplying the number of each part on hand by that part's price, and then adding the individual results. The formula, which is stored in cell D7, is {=SUM(B2:B6*C2:C6)}. Why are there curly braces around the formula, and why do I get a VALUE! error when I try to edit the formula?

Figure 3-14. The formula in cell D7 lets you skip a lot of partial calculations in cells D2:D6.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint