Divide by a count to give daily, monthly, quarterly results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
mtwelsh72 said:
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
Click to expand...

I would need to see how the data has been entered in order to answer.

/Fredrik
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Monthly percentage greater than a value 1
Increase Formula Cell Selection Based on Value 8
Using macro to set chart title with a variable month 2
how do you use microsoft excel to calculate year to date average 1
Tiered Cumlative Commisions By Month 1
Daily Average by quarter 9
Showing data per month & year for comparison 3
SUM referring to different sheets 1

Back
Top