Archive for February, 2010
NIFTY TIP #5: Adding or Subtracting Amounts from Different Ranges
Problem: You need to add or subtract amounts from different ranges (SUMIF function). Solution: Insert two SUMIF formulas and combine them into a single formula: Insert the SUMIF formula to total the amounts based on the criterion 701 into cell E2. Insert the SUMIF formula to total the amounts based on the criterion 300 into [...]
Nifty Tip #4: Organizing the Data Table for Proper Use of the VLOOKUP Formula
The VLOOKUP formula searches for the lookup criteria in the leftmost column of the data table. It is recommended that the whole sheet be used as the data table, so that the VLOOKUP will automatically look at column A as the leftmost column. Defining a Name for the sheet (to use it as the Table_array, [...]
Nifty Tip #3: CONCATENATE
A couple of the last Nifty Tips we’ve talked about were about splitting combined cells. That’s great, and it’s often useful, but what if you want to combine the contents of a cell? Maybe you’re writing a letter or sending an invoice, and it would just be easier to have someone’s name be in one [...]