Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divide by a count to give daily, monthly, quarterly results
Using Excel 2003
I have created a spreadsheet to track sales. However, when I go to my yearly tab to look at year-to-date percentages, the percentages reflect yearly data instead of year-to-date data. For example, we are in January and one of my sales teams is over 100%, however YTD figures is only reading 9%. How can the YTD cells reflect true YTD information rather than calculating data for the entire year. Thanks! Matthew |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divide by a count to give daily, monthly, quarterly results
"mtwelsh72" wrote in message ... Using Excel 2003 I have created a spreadsheet to track sales. However, when I go to my yearly tab to look at year-to-date percentages, the percentages reflect yearly data instead of year-to-date data. For example, we are in January and one of my sales teams is over 100%, however YTD figures is only reading 9%. How can the YTD cells reflect true YTD information rather than calculating data for the entire year. Thanks! Matthew I would need to see how the data has been entered in order to answer. /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
Monthly, Quarterly formulas | Excel Worksheet Functions | |||
Chart with Quarterly and Monthly Results | Charts and Charting in Excel | |||
I need a daily count sheet with a monthly total | Charts and Charting in Excel | |||
monthly quarterly splitting | Excel Discussion (Misc queries) |