Calculate Sales

Closed
51214
Posts
1
Registration date
Thursday November 8, 2012
Status
Member
Last seen
November 8, 2012
- Nov 8, 2012 at 01:15 AM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Nov 8, 2012 at 12:06 PM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
Nov 8, 2012 at 09:31 AM
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
0
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
70
Nov 8, 2012 at 12:06 PM
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.
0