0
You would use the AVERAGE function. You could also use the SUM function and then divide by the amount of values, which you could find with the COUNT function. You can directly type in the functions yourself, without using a wizard to do it. You should use some functions, rather than trying to do it manually, as that will give you the correct results.
Wiki User
∙ 8y ago
Wiki User
∙ 6y agoYou would use the SUM function and reference the cells with the appropriate figures, which could be all the individual sales or maybe totals for the months in that quarter. So it really depends on the layout of your worksheet. In that regard, it is impossible to give you a specific formula, but the SUM function is the one you would use.
Add your answer:
Earn +20 pts
What is revenue in excel?
Revenue is how much is earned, like in a business. As Excel deals with numbers, then calculating revenue is something that is regularly done in Excel.
Can the IF function in Excel be use to calculate future revenue?
Potentially it could be used that way, depending on what data you had and how you were calculating the future revenue. If the revenue is conditional on something, then it could be used. There are lots of financial functions that could be used in relation to revenue.
How do you calculate total room revenue?
how do calculate total of rooms revenue
What does average item revenue mean on Excel?
The revenue is how much is earned on each item. If you total up the revenue of all items and then divide by the amount of items there are, you will get the average revenue. You could use the Average function in Excel to do this.
What are 4 advantages of Microsoft Excel over Microsoft word?
In Excel you calculate and have alarge number of formulae to perform a variety of operations on the numbers you put into clls. In Word you write text and format written documents.
What is the formula for Net Operating Margin in Excel?
=(total revenue- total expenditures)/revenue. you get a percentage.
How do you calculate total revenue?
To calculate total revenue you simply multiply the quantity by the price. Total revenue includes expenses; therefore, total revenue isn't the same as profit.
How do you calculate gross margin if no sales or revenue?
u cannot calculate without sales or revenue. STUPID
How do you you calculate total revenue percentage?
You can calculate the total revenue percentage by substituting the variable X for the monthly revenue, the variable Y for the period of time, and then multiple these to solve for the total revenue percentage.
How to Calculate quarter over quarter revenue?
How to calcalate total revenue
How do you calculate the revenue?
tc-ac
How the calculate the revenue?
tc-ac
