I am not sure what I am doing wrong. For cell B22 I put in the formula and get the correct number but it is counted as wrong, Is there another way I could write this formula?

AutoSave On H2 SC EX 19 5a Nicole Hemperly_Report_1 - Excel A Nicole Klotkowski NK File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments X Century Gothic 11 - AA == a Wrap Text General - TH TIX W 48 4 Paste LG Merge & Center BIU- Insert Delete Format Ideas $ -% - Conditional Format as Cell Formatting - Table - Styles Styles Sort & Find & Filter - Select Clipboard Font Alignment Number Cells Editing Ideas C35 - fi Copy a formula into a range. F H I DE 0/7 32 33 34 35 36 B 8. Olivia wants to round the total sales values so that they are easier to remember. a. In cell B22, add the ROUNDUP function lo display the lolal sales for January rounded up lo 0 decimal places. b. Fill the range C22:F22 with the formula in cell B22. X Create a formula using a function. In the All Locations worksheet, the formula in cell B22 should contain the ROUNDUP function. X Copy a formula into a range. In the All Locations worksheet, the formula in cell B22 should contain the ROUNDUP function. 9. In cell F24, Olivia wants to display the total sales from the previous year for the same period. This data is stored in another workbook. Insert the total as follows: a. Open the file Support_EX19_5a_Sales.xlsx. b. In cell F24 of Olivia's workbook, insert a formula using an external reference to cell F22 in the All Locations worksheet in the Support_EX19_5a_Sales.xlsx workbook. 0/7 37 38 39 40 X Create a link to an external workbook The workbook should contain a link to the Support EX19 5a Sales workbook X Enter a number in a cell. In the All Locations worksheet, cell F24 should contain the same value as cell F22 in the All Locations worksheet in the Support_EX19_5a_Sales.xlsx workbook. 10. Olivia wants to visualize how the sales of each type of audio book contributed to the total sales for January to April ... Australia All Locations Sales Comparison New Location 41 4/7 Ready E + 10096 HE Type here to search O w X ? 2:22 PM 7/6/2020 AutoSave On H2 SC_EX19_5a_NicoleHemperly_2 - Excel A Nicole Klotkowski NK File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments X ThoLTI4 11 - AA == ab Wrap Text Accounting - TH TIX W 48 4 Paste LG BIU Ideas A- Insert Delete Format E Merge & Center $ - %329 Conditional Format as Cell Formatting - Table - Styles Styles Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Cells Ideas B22 X fi {=SUM(ROUNDUP(B16:B21,0))} B c D E F G H J K L 3,694 3,358 1,961 19,405 3,547 2,171 21,211 2,283 21,426 3,921 2,261 22,541 14,520 8,676 84,583 A 10 Science fantasy 11 Self-help 12 Total 13 14 15 Book Type 16 Adventure 17 Literary 18 Mystery 19 Romance 20 Science fiction 21 Self-help 22 Total 23 24 25 26 27 28 29 30 31 Sales: January - April January February March April Total 36,398.35 38,913.20 38,514.90 38,814.90 $ 152,641.35 17,776.65 20,076.05 17,088.45 16,872.70 $ 71,813.85 42,329.25 47,933.45 44,877.85 53,854.15 $ 188,994.70 37,810.45 40,939.00 47,556.00 47,458.30 $ 173,763.75 32,251.10 34,222.65 35,737.30 38, 112.95 $ 140,324.00 18,711.95 20,787.45 21,926.85 21,879.95 $ 83,306.20 $ 185,281.00 $ 202,875.00 $ 205,703.00 $ 216,995.00 $ 810,846.00 Total sales last year (Jan-Apr) Total Sales Self-help 10.1% Adventure 17.9% Science fiction 17.6% Literary 7.8% ... Canada Australia All Locations Sales Comparison New Location + Ready + 10095 HE Type here to search O w x (? 2:22 PM 7/6/2020