# Daily Sales Target Based On Yearly And Monthly

Jan 7, 2014

I have a problem here in calculating the Daily sales target based on Monthly Targets and Year End Target.

I am attaching the file herewith which has Yearly & Monthly Targets defined. Need calculating Daily targets which should match with Monthly & Year end target .

I have the split of day wise sales for a week as well in another tab. However not able to get the exact monthly target as listed .

## Summarize Monthly Sales From Daily Sales

Jan 5, 2010

I have daily basis monthly sales. Now I want to summarize into monthly gross. Pls look attached file. I am looking for a formula to summarize January daily sales from date 1st to 31 st as of just January and and sum of each day gross.

## Excel 2010 :: Sales Daily Sales Data To Be Aggregated Into Monthly Data (not Using Pivot Table)

Mar 27, 2013

I cannot solve with Excel 2010 and I have searched all over for the answer.

I have sales data that is approximately daily and would like to count the monthly data and summarize it as an average for the month in a separate column.

For example, I would like to turn this:

3/2/2005 \$xxxx
3/5/2005 \$xxxx
3/20/2005 \$xxxx
4/2/2005 \$xxxx
4/10/2005 \$xxxx

Into this:
March 2005- \$xxxx (monthly average)
April 2005- \$xxxx (monthly average)

I have a feeling some 'countif' formula would work but I am not sure how to do this.

## Producing Table Of Monthly Values Based On Monthly Growth Rate And Yearly Total

Mar 6, 2013

I have a table of yearly totals for the amount spent by x. I also have a growth rate for each month so for example in 2001 in jan the growth rate might have been 0.3% and feb 0.5% What I want to do is for each month based on the growth rate and the total produce a value for each month which sum to the total amount. It's also important to note that it restarts each year.

Link for excel file is here: [URL] ...........

## Calculate Monthly Sales Based On Data Given?

Jun 9, 2014

How to calculate the monthly sales based on the data given ?

## Monthly Increase Based On Annual Target

Nov 17, 2007

I am trying to figure a formula that will give me a monthly increase with a annual target. Example:

2006 sales were \$100,000 and December 2006 sales were \$9,000.

For 2007 I would like a 10% increase in sales which means I should end up with \$110,000 at the end of 2007.

The formula should figure a gradual sales increase each month until December 2007. I am assuming the business sales trend is upward with no seasonality so that January 2007 should be the annualized increase over December 2006.
.
I have used the formula =100000*((1+.1)^(1/12)-1) which works for 2007, but it gives me a large jump between December 2006 and January 2007 and then a slight increases each month.

## Using Rolling 12 Month Sales And Minimum Monthly Sales?

Oct 17, 2013

I have a sales level that I need to track...My rolling 12 months' sales must be \$85,000 and my currently monthly sales must be \$7,000. I have a sheet that tracks the \$85,000 and tells me what I need to achieve that, but I haven't figured out how to include the \$7,000 monthly minimum....

The chart below is what I have. So for example, this month it's telling me I only need to sell another 3016.46 to hit the \$85,000 rolling 12, but I actually need to hit \$4821.79 to meet the \$7k minimum.

Actual Rolling 12 Goal
Sep 2012 5,367.24 73,663.30
Oct 2012 5,649.93 69,496.28
Nov 2012 14,163.38 73,451.30 [code]....

## Copy Week Total In Weekly Sales Worksheet To Appropriate Week In Monthly Sales

Oct 14, 2009

I need to copy the values of a range on the weekly sales worksheet to the monthly sales worksheet. The last column is the total on the weekly sales. Part of the heading of the total column is the week ending date (e.g. 10/17/2009. On the Monthly Sales I have the months in columns by week ending (e.g. 10/17/2009).

Range I4:I28 to the monthly sales worksheet by date.

## Sheet For Daily Sales

May 18, 2009

I have a query regarding making a Excel Sheet for Daily sales.

here I go,
Well i want to make an Excel Sheet where in I just need to enter the Date, Invoice Number , Product , No of Product and rest it should calculate the VAT (Rounding Off) amount N den the Grand Total..

M givin you an example in the Below Sheet.

## Creating A Yearly Database File Using Information In Daily File

Feb 7, 2008

I would like to automatically update a 'yearly' database file with info from a file that is changed on a daily basis.

The daily file that i use has info like date, truck number, delivery stops, weight.

the database file has the similar headings.

at the end of each day this daily file is saved. I would like to have the info that is entered into the daily file automatically plugged into the yearly database file into the next available group of cells with respect to the salesperson.

This is kind of a generalization but i'm hoping to just get pointed in the right direction. If something like this involves vba then it will be beyond my ability and i'll have to do it manually, which is fine

## Daily Target With % Growth?

Feb 3, 2014

what i need to do to track daily sales with 10% growth from previous year total sales.

I have 12 separate sheets for each month.

On each sheet i have separate columns"date" "goal" "actual" "% from goal".

What function/formula is needed to calculate the daily target goal taking into account that weekends are busier

## Daily Sales Sheet To Refresh With Every Day

Jul 15, 2014

I am trying to build a sales sheet that will keep all the records during the month but every day it refreshes to a blank sheet, then allowing users to flick back to a previous day and all the data from then is still saved?

I think this is possible in excel as I am sure I have seen a working sheet before but I don't know where to start or even what the process would be called in excel?

## Subtracting Monthly Sales From Constant?

Dec 12, 2013

I have sales per month going down a column and I would like to subtract a corresponding \$ amount going across columns. It's hard to explain but I would like a formula that I can populate all of the cells with. Spreadsheet should make it clearer.

## How To Add Monthly Sales Data Using Formula

Dec 29, 2013

How can I add data to the monthly sales section in the workbook? I can't seem to figure out the code.

mockup.xlsx

## Sum Daily To Monthly Amounts

Apr 7, 2014

How to write a macro that will sum daily figures into monthly figures? On the attached spreadsheet I would like to take the daily figures on the amounts on the VRU DAILY worksheet and sum them in the appropriate month on the VRU # sheet.

## Turning Monthly Data Into Daily?

Jul 26, 2014

Is it possible to turn monthly data into daily? Repeating the same data for four sets of five working days to turn a CPI monthly inflation index into daily data, to turn example 1 into example 2.

Example 1.

DATEVALUE
2008-01-01 212.174
2008-02-01 212.687
2008-03-01 213.448
2008-04-01 213.942
2008-05-01 215.208

Example 2:

2008-01-01 212.174
2008-01-02 212.174
2008-01-03 212.174
2008-01-04 212.174

## Monthly Average From Daily Data

Oct 28, 2011

I have data in the following format (columns A & B):

Code:
Day Value
1/1/2002 2.1
2/1/2002 4.8
3/1/2002 0.1
" "
" "
" "
31/12/2011 5.2

I'd like to be able to write a formula so that I can get the daily data averaged over each month, e.g so that I have something like:

Code:
Day Value
Jan 2002 3.3
Feb 2002 4.3
Mar 2002 3.1
" "
" "
" "
Dec 2011 4.2

I'd like the data in monthly averages so that I can graph them. I have read about array formulas and averageif statements, but I can't seem to combine them to make them work.

## Finding And Calculating Highest Trending Item By Daily Sales?

Apr 20, 2012

I have a very large spreadsheet with daily sales for over 140 different items, over the past 2 years.

This is how my data looks like:

ITEM NAME 4/1/12 4/2/12 4/3/12 etc
item1 10 15 500
item2 5 0 3
item3 0 0 5
etc

I'm trying to build a formula that allows me to see which item is the highest trending over a period of time I input.

I figured out the way how to select data between specific Start and End dates, but don't know how to interpret "trending" in a formula.

I was thinking maybe highest jump from beginning to end of interval, but what if it's a new item that was launched halfway through the interval and does poorly throughout, that would still be "trending" under that rationale....

## Conditional Formula- Worksheet With Monthly Sales Figures

Aug 5, 2008

I have a worksheet with monthly sales figures by associate and by store. The store has a monthly goal as do the associates. If the store hits it's goal then the overall sales total is multiplied by 1% and then divided by the percentage of each associates involvement to reach that goal. (ie...150,000*1%=1,500, John sold 35,000=23%, so John gets \$345 extra commission). If Johns goal was \$25,000 and sold \$35,000 he gets 1% or \$350 commission. In turn, if he meets 1 or both sets of criteria those will be added together. If he doesn't meet either one then the result is Zero.

I have the store goal and Johns goal in separate cells to reference against. The actual sales cell is formula based.

This is basically what i'm trying to do:
If criteria 1 is met then % of 1% of store goal, if criteria 2 is met then 1% of individual goal, if both are met result1+result2. if neither is met then zero. I think?

## Categorized Daily Expense To Monthly Basis

Jan 8, 2010

While I was working my daily expense I come up with this issue. I do eat outside while I am on work. Sometimes I go to Pizza, sometime I go to mexican etc etc. The common between them is word FOOD. I would like to modify the formula suggested by Ron Coderre

=SUMPRODUCT((TEXT(\$A\$2:\$A\$14,"mmm")=\$E3)*(\$B\$2:\$B\$14=F\$2)*\$C\$2:\$C\$14)

See the attached file to get more idea of my question. Then I would Like to Highlight Entire Rows which contains a Specific text.

## Daily Data Conversion To Monthly Totals

Sep 9, 2013

I have a daily rainfall data and I want to convert it to monthly totals. I tried the pivotal table but the arrangement of the data seemed to be confusing (i.e the year, month and day are in different columns).

See the attached data: Raindata_excel_forum.xlsx‎

## Summing Daily Weekly & Monthly Totals

Feb 26, 2009

I assume there's a database (or pivot table?) solution for my task, which is to detect the days, weeks and months within a very long table, and obtain the totals of the data therein.

See attached worksheet.

## Determining Top Contributors To 50% Of Sales Based On Cumulative Percent Of Sales

Jul 2, 2009

I am trying to determine the top contributors to 50% of sales based on cumulative percent of sales (see attached file). I can determine if percent of sales is less than 50%, but I need to include the person that pushes the group of top performers over the 50% mark.

## Computing Monthly Standard Deviation From Daily Data

Apr 7, 2014

I have to compute monthly standard deviation (volatility) from daily data.

The problem consists on the fact that the days during a month are not constant and change over time.

I attach the excel file : Price_Time_Series.xlsx

In this xls file, you can find dates in column A, price in column B and returns in column C.

I want to compute standard deviation at the end of the month for stock returns (column C), by considering all available days.

As you can note from the file, the days change over time and they are note constant. How can I compute standard deviation of them?

## Automatically Create Monthly Totals From Daily Data

May 20, 2014

I am trying to do an automatic input with my daily total sales.. i did it in total but my problem is i don't know how to make the date change.

## Automatically Create Monthly Totals From Daily Data

Jan 2, 2009

In column A I have dates, in column B I have data.

What I am trying to do is get the monthly totals from the data so instead of:

01/02/08 - 52
06/02/08 - 87
14/03/08 - 23
12/13/08 - 12

I would get:

Feb 08 - 129
Mar 08 - 33

## How To See Percentage Of Items Received Daily / Weekly / Monthly

Apr 20, 2013

I'll use following as an example.

I work for a supermarket, I receive many fruits per day and I want to see what percentage of them are bananas, apples, oranges, watermelons etc.

Are there any templates of pie charts and bar graphs that I can use for this that will show the percentage of said fruits daily, weekly and monthly?

## Calculate Monthly Standard Deviation From Daily Data

May 11, 2008

I've daily data of a stock indices returns and I would like to calculate the monthly standard deviation. Currently, I'm using the following worksheet functions: =STDEVP(C2:C20)*SQRT(COUNT(C2:C20))

However, the range changes from month to month, which makes the process of calculating the monthly standard deviation to be quite tedious if I've about 10 years worth of data. I assume I could somehow substitute the range with a dynamic range, but I'm struggling to come up with the correct formulation that would do that.

## Tracking Daily Total Sales And Individual Tender With Data Extracted From .dbf File.

May 23, 2006

I want to track daily sales of a shop with the tenders (Cash, Master, Visa)seperated.

Everyday there will be a file ctp.dbf from a folder YYYYMMDD (previous day date) which contains sales details.

I tried to use sumif commands and everything is working fine. everytime i have to open book.xls and from it I do a files>Open to open the ctp.dbf for the calculation to be done. is there a way where by i can open 1 file and everthing i calculated properly?

Also this book.xls can only do for 1 day how can i go about having the daily sales detail of the month (look something like sales summary.xls) or even year in 1 excel file?

attached is book.xls and sales summary.xls for reference.

## Excel 2007 :: Modify / Transform Daily To Weekly Or Monthly Data

Nov 14, 2013

I have an excel 2007 script that downloads daily stock data and prices. I do analysis and graph the data.

I would like to keep the download the same, but modify my analysis so as to obtain weekly and/or monthly data.

I am sure this is commonly done, and is not rocket science, but so far I am baffled as to the procedure / algorithm to do this.