Question: 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

 In cell E15, enter a formula using a counting function to

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 Formatting - as Table - Styles Styles Clipboard Font Alignment Number E15 f B D E F G H 1 J 230 479 6,538 21 84 70 1 Date 2 10/1/2016 3 10/3/2016 4 10/3/2016 5 10/4/2016 6 10/6/2016 7 10/6/2016 8 10/9/2016 9 10/15/2016 10 10/16/2016 11 10/17/2016 12 10/23/2016 13 10/25/2016 14 10/28/2016 15 16 C Category SubCategory Billable? Cost Rent Parking Computer Expense Internet Access $ Computer Expense Server Rental X $ Travel & Entertainment Meals X $ Computer Expense Equipment $ Travel & Entertainment Taxi $ Computer Expense Equipment X $ Computer Expense Equipment $ Travel & Entertainment Meals X $ Computer Expense Software $ Computer Expense Software $ Office Expenses Coffee $ Travel & Entertainment Hotel S How many expenses are billable? How many expenses are not billable? 241 398 37 210 40 57 121 Total number of expense line items 17 18 19 20 21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!