What is the function to make sumifs following by this expalanation?

cell beginning with cell A4 on the Contribution worksheet. The function should combine the words "Fiscal Year: "and the year that is entered into cell B1. Note that there are two spaces that should be added after the colon following the words "Fiscal Year". 3. Enter a SUMIFS function into cell C5 on the Contribution worksheet that sums the Sales Revenue on the Sales and Cost Data worksheet based on the year that is entered into cell B1 on the Contribution worksheet. The data to be summed is in Column E on the Sales and Cost Data worksheet. The function should find a match in the Year column on the Sales and Cost Data worksheet to the year entered in cell B. The function should also find a match to the item in cell A5 (Sales Revenue) in Column C on the Sales and Cost Data worksheet. Add cell capacity to include Row 100 on the Sales and Cost Data worksheet. 4. Enter a SUMIFS function into cell B7 on the Contribution worksheet that sums the variable product costs on the Sales and Cost Data worksheet. The setup of this function is identical to the SUMIFS function in step 3 with the following changes: This function should find a match to the Font is Alignment Clipboard Number 05 D A B 1 Year 2019 2 Contribution Format Income Statement 3 Fiscal year2019 5 Sales Revenue 6 Variable Cost 7 Product 8 SG&A 9 Total Variable Cost Sales UI Sales Ta Sales Ta Variable Contribu Contribut 10 Contribution Margin 11 Fixed Cost 12 Product 13 SG&A 14 Total Fixed Cost Target P 15 Net Operating Income 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Clipboard Font Alignment Number f A1 Year N A B D Year Quarter Item Behavior 2019 1 Sales Revenue Sales 3 2019 2 Sales Revenue Sales 4 2019 3 Sales Revenue Sales 5 2019 4 Sales Revenue Sales 6 2020 1 Sales Revenue Sales 7 2020 2 Sales Revenue Sales 8 2020 3 Sales Revenue Sales 9 2020 4 Sales Revenue Sales 10 2021 1 Sales Revenue Sales 2021 2 Sales Revenue Sales 12 2021 3 Sales Revenue Sales 13 2021 4 Sales Revenue Sales 14 2019 1 Sales Units Sales 15 2019 2 Sales Units Sales 16 2019 3 Sales Units Sales 117 2019 4 Sales Units + Sales 18 2020 1 Sales Units Sales 19 2020 2 Sales Units Sales 20 2020 3 Sales Units Sales 21 2020 4 Sales Units Sales 22 2021 1 Sales Units Sales 2021 2 Sales Units Sales 24 2021 3 Sales Units Sales 25 2021 4 Sales Units Sales 26 2019 1 SG&A Variable Cost 27 2019 2 SG&A Variable Cost 28 2019 3 SG&A Variable Cost 2019 4 SG&A Variable Cost 30 2020 1 SG&A Variable Cost E Value 50050 70200 124995 175000 65000 70125 120000 153000 45000 65000 126000 165750 770 1170 1923 2500 1000 1275 2400 3400 1000 1300 2100 2550 3657.5 5557.5 9.134.25 1 1875 23 29 750 B c 2 SG&A Variable Cost 3 SG&A Variable Cost 4 SG&A Variable Cost 1 SG&A Variable Cost 2 SG&A Variable Cost 3 SG&A Variable Cost 4 SG&A Variable Cost 1 SG&A Fixed Cost 2 SG&A Fixed Cost 3 SG&A Fixed Cost 4 SG&A Fixed Cost 1 SG&A Fixed Cost 2 SG&A Fixed Cost 3 SG&A Fixed Cost 4 SG&A Fixed Cost 1 SG&A Fixed Cost 2 SG&A Fixed Cost 3 SG&A Fixed Cost 4 SG&A Fixed Cost 1 Product Variable Cost 2 Product Variable Cost 3 Product Variable Cost 4 Product Variable Cost 1 Product Variable Cost 2 Product Variable Cost 3 Product Variable Cost 4 Product Variable Cost 1 Product Variable Cost 2 Product Variable Cost 3 Product Variable Cost 4 Product Variable Cost 1 Product Fixed Cost 2 Product Fixed Cost 3 Product Fixed Cost 4 Product Fixed Cost 1 Product Fixed Cost Contribution Sales and Cost Data 6056.25 11400 16150 4750 6175 9975 12112.5 30000 30000 30000 30000 30000 30000 30000 30000 30000 30000 30000 30000 19250 292501 48075 62500 25000 31875 60000 85000 25000 32500 52500 63750 15000 15000 15000 15000 15000 9 9 9 0 0 20 20 21 21 21 2011 19 19 19 19 20 2021 2019 2019 2019 2019 2020 2020 2020 2020 2021 2021 2021 2021 2019 2019 2019 2019 2020 2020 2020 2020 2021 021 2021 2021 4 SG&A 1 Product 2 Product 3 Product 4 Product 1 Product 2 Product 3 Product 4 Product 1 Product 2 Product 3 Product 4 Product 1 Product 2 Product 3 Product 4 Product 1 Product 2 Product 3 Product 4 Product 1 Product 2 Product 3 Product 4 Product Fixed Cost Variable Cost Variable Cost Variable Cost Variable Cost Variable Cost Variable Cost Variable Cost Variable Cost Variable Cost Variable Cost Variable Cost Variable Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost Fixed Cost 19250 29250 48075 62500 25000 31875 60000 85000 25000 32500 52500 63750 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 3 9 0 1 -2 23 74 75 76 77 78 79 80 81 82 83 84 Contribution Sales and Cost Data +