Question
6. Excel Calculate the total and average sales by region. In cell B10 , use a SUMIF formula to calculate the sum of AnnualSales where
6. Excel
Calculate the total and average sales by region.
In cell B10, use a SUMIF formula to calculate the sum of AnnualSales where the value in the Regions named range is equal to the region listed in cell B9.
Copy the formula to cells C10:I10.
In cell B11, use an AVERAGEIF formula to calculate the average of AnnualSales where the value in the Regions named range is equal to the region listed in cell B9.
Add a rounding function to the formula in cell B11 to round the result to two decimal places.
Copy the formula to cells C11:I11.
If necessary, format cells B10:I11 with the default Accounting Number FORMAT
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Accounting For Investments Equities Futures And Options Volume 1
Authors: R. Venkata Subramani
1st Edition
047082431X, 978-0470824313
