answersLogoWhite

0


Best Answer

You would use the SUM function, specifying the cells that have the various revenues for the year. It will depend on what cells you are using. If you have one for each month in the cells from C2 to C13, the function would be as follows:

=SUM(C2:C13)

User Avatar

Wiki User

7y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you enter the formula that will calculate the total revenue of the year 2006?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the formula to calculate profit?

A simple profit formula reconciles revenue to losses and expenses. Profit equals the total revenue subtracted by losses and expenses.


How do you calculate total room revenue?

how do calculate total of rooms revenue


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.


What is the meaning of ARR in hotel industry?

ARR is known as AVERAGE ROOM REVENUE, the formula to calculate is TOTAL ROOM REVENUE divided by NO OF ROOMS SOLD


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


What is the formula for Net Operating Margin in Excel?

=(total revenue- total expenditures)/revenue. you get a percentage.


How do you calculate marginal revenue cost by math and graphically and marginal in general?

Profit=Total revenue - Total cost


How does a firm calculate its profit?

total revenue minus total cost


How do you calculate net loss?

To calculate net loss, subtract total expenses from total revenue. Net loss occurs when expenses exceed revenue, resulting in a negative value. The formula for net loss is: Net Loss = Total Revenue - Total Expenses.


How do you calculate total revenue in microeconomics?

Tr=p.q


What is the formula for Total Revenue and Total Cost?

Total revenue equals the sale price of products multiplued by the total amount of units sold