Previous Topic Next Topic

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 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
Answer 2 / 2
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response