how to compute the total sale of a fastfood store using Ms excel note
Share
how to compute the total sale of a fastfood store using Ms excel note
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
Enter "=sum(B1:B#)" in the next empty cell in the B column, and replace "#" with the row number of the last filled cell in column B. In the example, you would enter "=sum(B1:B2)" in cell B3 to calculate the total sales of the two items.
explanation:
An Array Formula performs an Excel operation (math, comparative, join, or function argument) on an array or range of data. This could be a range of cells, a worksheet reference, or a defined name.
One of the most popular uses of an array formula is to calculate Total Sales in Excel.
If we had to calculate Total Sales in Excel the normal way, we would have to create a “helper column” for the Totals column and then enter a formula to Sum all the Totals.
Step-by-step explanation:
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
If we had to get the above result using a non-Array Formula we would have to create a helper column which multiplies UNITS SOLD by UNIT PRICE and then enter the SUM formula to get the same result. This is double the work!