Question

hello, how to calculate total sales in excel?

hello, how to calculate total sales in excel?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

example of an Array Formula to Calculate Total Sales in Excel for various products.

Follow the step-by-step guide below on How to calculate Total Sales in Excel:

STEP 1: Enter the SUM formula =SUM(

STEP 2: Select the array/range of data for the UNITS SOLD, enter the multiplier sign * and select the array/range of the data for the UNIT PRICE:

=SUM(C13:C16*D13:D16)

STEP 3: Instead of pressing ENTER to evaluate the formula, you need to press CTRL+SHIFT+ENTER to turn the formula into an Array Formula which will look like this:

{=SUM(C13:C16*D13:D16)}

STEP 4: By pressing F9 on the selected formula array will give you the resulting array of numbers (press CTRL+Z to get out of this mode when you are done checking the formula results):

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Hello, something I'm doing on Excel is wrong and need to know how to do this...
Hello, something I'm doing on Excel is wrong and need to know how to do this correctly on Excel, now written out. A sample of the sales at 50 Haute Dog restaurants is taken and the sample mean is $30,000 per day with a sample standard deviation of $2000. The population standard deviation is not known. a. What is the 90% confidence interval for the daily sales at all restaurants. b. What is the probability that the average sales are...
How to calculate in excel the following Please show formula - Calculate (a) MAD, (b) MSE,...
How to calculate in excel the following Please show formula - Calculate (a) MAD, (b) MSE, and (c) MAPE for the following forecast versus actual sales figures. (Please round to four decimal places for MAPE.) Forecast Actual 100 95 110 108 120 123 130 130
How do you calculate NPV and IRR? With excel
How do you calculate NPV and IRR? With excel
hello, my question is, how can i use implicit differentiation to calculate the optimal surface area...
hello, my question is, how can i use implicit differentiation to calculate the optimal surface area of a box. Or any type of optimization problem involving the use of implicit differentiation. an example would be appreciated
Calculate the return on assets managed (ROAM) of a branch whose total sales are $3,000,000, total...
Calculate the return on assets managed (ROAM) of a branch whose total sales are $3,000,000, total assets are $1,500,000, gross margin is $500,000, and branch expenses are $200,000. A. 5.0% B. 16.7% C. 10.0% D. 20.0%
2. Calculate number of times hello is printed. #include <stdio.h> #include <sys/types.h> int main() { fork();...
2. Calculate number of times hello is printed. #include <stdio.h> #include <sys/types.h> int main() { fork(); fork(); fork(); printf("hello\n"); return 0; }
using excel sheet to calculate 1. Firm A's sales last year = $280,000, net income =...
using excel sheet to calculate 1. Firm A's sales last year = $280,000, net income = $23,000.  What was its profit margin? (8.21%) 2. Firm A’s total assets = $415,000 and its net income = $32,750.  What was its return on total assets (ROA)?(7.89%) 3. Firm A’s total common equity = $405,000 and its net income = $70,000.  What was its ROE? (17.28%) 4. Firm A’s stock price at the end of last year = $23.50 and its earnings per share for the...
Excel has a formula to calculate Net Present Value. Explain how the formula is used to...
Excel has a formula to calculate Net Present Value. Explain how the formula is used to perform the calculation. Specifically, identify each component of the formula and explain its meaning.
Hello, Are you able to assist with the below? And show all work? Thanks. Exam Company...
Hello, Are you able to assist with the below? And show all work? Thanks. Exam Company manufactures two modular AV entertainment systems; one for the residential (home) market, and the other for the commercial (office) market. Budgeted and Actual operating data for the year 20x1 are: Budgeted Actual Types of System Home Office Home Office Number of Units Sold          24,000          8,000          22,475          6,525 Budget Contribution $225 $350 Margin (per unit) Required i. Calculate the Sales-Volume Variance...
Hello I am working on my assignment for management class. I have calculated the total asset...
Hello I am working on my assignment for management class. I have calculated the total asset turnover ration for year 2015 and 2016 by using this formula. Total asset turnover ratio= total operating revenues/ total assets year 2016= 1378287738/1567838211= 0.87 year 2015= 1227830814/1384461557= 0.88 My question is how can i know the benchmark?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT