create formula

Task 3 of 10 S Q 3 C Assignment: Training: Analyzing Dat... Task: EX8873 Create a formula u... Guide ? Search M Apply Submit + Ask new AutoSave . Off H Rockland Financials.xIsx - Excel Sign in X D18. File Home Insert Page Layout Formulas Data Review View Tell me what you want to do Shar 2. Understand the COUNT Function: Calibri 11 - A" A % Paste BIU - - - A . Alignment Number Conditional Format as Cell Cells Editing . The COUNT function is used to count the number of cells that contain Formatting * Table Styles Clipboard Font Styles numeric values in a specified range. A6 ... X Dallas 3. Enter the Formula in Cell D19: A B C D E F G H . Click on cell D19 to select it. R C . Type in the formula: 1 =COUNT ( D5 : D18) Sales by Branch 2019 Total Sales Continue with 2020 2021 4. Press Enter: 3 over 3 Years Branch? 4 Deerfield $85,000 $120,000 $134,910 $339,910 . After typing the formula, press Enter to execute it. The cell will now 5 New York $48,500 $72,000 $78,500 $199,000 display the count of numeric values in the specified range. 6 $47,500 $59,500 $47,500 $154,500 7 San Diego $38,150 $47,500 $39,500 $125,150 Explanation of the Formula 8 Total $219,150 $299,000 $300,410 9 . =COUNT (D5 : D18) 10 11 12 13 . This tells Excel to count all the cells in the range D5 to D18 that contain 14 15 16 17 Ask Al your follow up question. Do not enter personal information. 18 Task Instructions X 19 20 21 In cell F4, enter a formula using the IF function that Sales by Branch returns a value of YES if cell E4 is greater than 100,000, ... ...+ Image Document and a value of NO if not. Ready O Type here to search e 11:56 PM 3/25/2020