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
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
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...
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?
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...
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.
A company had the following sales transactions: Total debit card sales = $240,000. Total credit card...
A company had the following sales transactions: Total debit card sales = $240,000. Total credit card sales = $430,000. Total cash sales = $820,000. Total check sales = $110,000. There is a charge of 3% on all credit card transactions. Calculate total sales revenue recorded for the year.
i need to know on excel how to calculate the yield to maturity of a bond...
i need to know on excel how to calculate the yield to maturity of a bond with the information below. it can be random numbers Number of periods Present value (price) Face value Coupon rate i also need a second calculation that shows me the YTM if this bond pays semi-annually instead of annually it can be random numbers.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT