In Cell E15, Enter A Formula Using A Counting Function To Count The Numbers In The Cost Column (Cells E2:E14). Expenses - Excel File Home Insert Page Layout Formulas Data Review Calibri 11 ? ?? * Cut 6 Copy Format Painter View Tell Me What You Want To Do.. Wrap Text General Merge & Center $ % Paste 1 BIU Y - A - ?? +0.00 .00 0 Conditional Format Cell

 

 

 

 

In cell E15, enter a formula using a counting function to count the numbers in the Cost column (cells E2:E14). File Home Insert Page Layout Formulas Data Review View Tell me what you want to do... Cut Wrap Text Calibri 11 AA General Copy Merge & Center Paste BIU A $ % " +.0 .00 +.0 .00 Format Painter KJ Clipboard G Font Alignment Number E15 fx G Expenses - Excel Cell Conditional Format Formatting as Table Styles Styles A B E F G H 1 Date 2 10/1/2016 Category Rent SubCategory Billable? Cost Parking $ 230 3 10/3/2016 Computer Expense Internet Access $ 479 4 10/3/2016 5 10/4/2016 6 10/6/2016 7 10/6/2016 Computer Expense Travel & Entertainment Computer Expense Travel & Entertainment Server Rental X $ 6,538 Meals X $ 21 Equipment X $ 84 Taxi X $ 70 8 10/9/2016 9 10/15/2016 10 10/16/2016 Computer Expense Computer Expense Equipment X $ 241 Equipment $ 398 Travel & Entertainment Meals X $ 37 11 10/17/2016 Computer Expense Software $ 210 12 10/23/2016 Computer Expense Software $ 40 13 10/25/2016 Office Expenses Coffee $ 57 14 10/28/2016 Travel & Entertainment Hotel X $ 121 15 16 How many expenses are billable? How many expenses are not billable? Total number of expense line items 17 18 19 20 21 J