0
Without having the actual layout of your worksheet and seeing where the cells are that you have your figures in, it is impossible to give a definitive answer. It will involve using the SUM function to sum up the individual sales for a particular month. So if your list of sales were in the cells C3 to C25, your formula would be:
=SUM(C3:C25)
So it is a matter of adjusting the formula to suit the cells that you have your data in.
What else can I help you with?
How would you calculate a formula for your monthly sales profit and inventory?
bhghnf
How do you make a monthly formula for sales?
now i don't know by the hope to memorize in feuture
What of these in Microsoft excel should be used to determine the total value of a column containing average monthly sales for a sales department?
To determine the total value of a column containing average monthly sales in Microsoft Excel, you should use the SUM function. This function adds up all the values in the specified range of cells. For example, if your average monthly sales are in column B from rows 1 to 12, you would use the formula =SUM(B1:B12). This will provide you with the total sales for that period.
Calculate monthly sales growth?
To calculate monthly sales growth a sales company needs to compare the sales from a previous month with that of the current month. If current sales is divided by a previous month sales, the end result will be the percentage of sales growth.
What is the formula for net sales?
Formula for net sales is as follows: Net sales = Actual sales - sales returns and discount allowed
How calculate expense-to-sales ratio?
sales to expense ratio should be under 10% of your net sales, on a monthly basis
What is monthly sales?
reduces prices given every month
What is formula of sales price?
The sales price formula is Sale Price=(Normal Price)(Compliment of Markdown)
How do you find contribution margin percentage?
Formula for contribution margin ratio = Sales
Megan works for Zipper Mart where she earns a monthly salary plus 3.5 percent commission on sales Compute her monthly gross pay if she is paid 200.00 a month and has sales of 5500.00?
392.50
How do you calculate the Contribution margin ratio?
sales-variable cost= contribution
What is the formula of net sales?
Net sales = Gross sales - (Customer Discounts, Returns, Allowances)
