Calculate Sales

[Closed]
Report
Posts
1
Registration date
Thursday November 8, 2012
Status
Member
Last seen
November 8, 2012
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Hello,

I want to keep track of my sales.I have four columns.Below is excel data.
Show only one day at a time.
Date X Y Z
08-11-12 -- -- --(this represent today sales)

This Month -- -- --(update dynamically)
This Year -- -- --(update dynamically)

Please guide me,how to do this in excel?
Do i need to use arrays?



2 replies

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi 51214,

Could you upload you file (with .xls extention) to a file sharing site like www.speedyshare.com.

Your file should contain sample data as it is now and how you would like to see it.

Best regards,
Trowa
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Hi 51214,

An easier way to do this would be to use the Pivot Table and then group the data in Months and Years. You can watch this YouTube video for more details:

https://www.youtube.com/watch?v=Gq_-UTSEwOE

This video shows more than one method for doing this.

Please revert for clarification.