Enter a formula in the selected cell using SUMIF to calculate the total expenses for the category Office Expense. Use the range name Category for the Range argument, the text string "Office Expense" for the Criteria argument, and Cost for the Sum_range argument. Expenses - Excel File Home Insert Page Layout Formulas Data Review View Tell me what you want to do... IAI Calibri - A A 11 == General AutoSum D D ED FA I & Cut e Copy Format Painter Et Wrap Text Merge & Center - Fill Paste BIU 7 Y Insert Delete Format A $ - % ) +0.00 .000 Clear - Conditional Format Cell Formatting as Table - Styles Styles Z Sort Find & Filter & Select Editing Clipboard Font Alignment Number Cells F2 A B C D E F G . 1 J K L M N o P Q R S Total Office Expenses $230.00 6 1 Date Category SubCategory Cost 2 10/3 Office Expense Parking 3 10/6 Travel & Entertainmenteals 4 10/15 Computer Expense Internet Access 5 10/25 Computer Expense Software 10/31 Travel & Entertainment Meals 7 11/1 Office Expense Parking 8 11/5 Travel & EntertainmentMeals 9 11/9 Travel & Entertainment Meals 10 11/12 Office Expense Postage and Deliveries 11 11/14 Office Expense Coffee 12 11/14 Office Expense Parking 13 11/19 Computer Expense Equipment 14 11/26 Office Expense Postage and Deliveries 15 12/2 Office Expense Parking 16 12/7 Office Expense Water Service 17 12/12 Travel & EntertainmentHotel 18 12/13 Computer Expense Internet Access 19 12/16 Office Expense Books 2012/16 Office Expense Office Supplies 21 12/18 Office Expense Books 22 12/18 Personnel Training $20.83 $579.00 $39.99 $6.29 $230.00 $15.91 $49.99 $79.96 $58.86 $410.00 $6,538.00 $225.00 $245.00 $92.53 $496.64 $112.16 $10.48 $37.66 $20.76 $249.00 23 24