SAMPLE COST AND PRICE ANALYSIS WORKSHEET.doc

Click the OK button when finished. Excel updates the formula bar to read =sumIF(B2:B9,“In Stock”,C2:C9). Lesson Example. Your office supplies vendor offers a 10% discount on all orders $300 and over. You are also wondering how many items you ordered with a Category Code of LEK. ................
................