Using Formulas to Conditionally Summarize Data 293
Using SUMIF 293
Using SUMIFS 296
Using COUNTIF 297
Using COUNTIFS 298
Using AVERAGEIF 299
Using AVERAGEIFS 300
Complete Step-by-Steps Pages 293-300)
Using Formulas to Look Up Data in a Workbook
Using VLOOKUP /HLOOKUP