Calculate Sales

Hi

Your request is not clear.

Pls, upload a small sample workbook.

And wherw are the sales day by day?

I think you could do a lookup / index and match to get today sales.

However, I suppose you need to show how your database look like (the file where data are inputted).

Depending on the format of this database, then could a formula be made to pull the sales data.

My understanding is that, today sales normally are input or transferred into database at the end of the day or the next day.

Is it correct to say that your request is to see the previous day sales from the database?

Sorry but no sense for me. Maybe someone else is able to understand your requietment.

Originally Posted by Fotis1991

Sorry but no sense for me. Maybe someone else is able to understand your requietment.

I think edesign95 want the end result to appear same as the file that he had uploaded.

@CRZU

Yes, but in this case he has to say us where are his data and how looks like. Doesn't he?

I believe that SUMIF(S) will do the job, but i can't be sure without more informations.

You need first determine how your database format be look like.

Before you can even start pulling the data.

As different format will require different formula. For your case, it could be
- SumIF
- Sumproduct
- Index & Match
- HLookUp or VLookUp

If you are going to build from scratch. Then you need to first find out how you are going to have the data input into the excel?

Manually or system download?

Manually, how often you want it to be input. System, I believe it could be real time data.

Result is the goal, but deciding the first step is important to determine the path.

Take a look to the example and let us know if this helps you.

You are welcome. Thanks for the reb*

@ edesign95

Attached is one of the sample you could use. Normally, apart from volume, business would also look at the profit.

In the summary page, I had set the formula so that you could also change the date instead of today date.

This way, it will pull out the day and month and year of sales you required.

For today sales result, you could simply set as today date then you right click the tab, move or copy, and select new book, then select all, copy and paste value in the new book.

This file can then be sent to the sales person or whoever you want to send.

If this help you, please click on the * at the right side =) to give me some rep.

definitely.. you could reward me rep for each job done so that I got enough rep to post a profile picture.. haha..

@ crzu.

...so that I got enough rep to post a profile picture.. haha..

Reb has nothing to do with profile picture..

Read the forum rules to learn when and how you'll get a profile picture.

Once you have been registered for 60 days and posted 100 posts your user title will change from Registered User to Forum Contributor, you will be able to upload a non-animated avatar. When you get to 120 days registered and 200 posts, your title will change to Valued Forum Contributor and you will be able to upload an animated avatar. When your title reaches Forum Guru you can upload a profile picture, we will leave you to wonder how long you have to be registered and how many posts for that!.

@ Fotis1991

Wow.. Thanks alot.. I saw most user with photo has the long green bar.. look like some power chart to me haha..

Wahh.. Base on the explanation.

60 days, 100 posts ==> Forum Contributor
120 days, 200 posts ==> Valued Forum Contributor
240 days, 400 posts ==> Forum Guru

I think I am close to 60 days, 58 more posts to reach Forum Contributor....

180 days more then can I upload my profile picture X___X... I still take some time to edit a cute picture.. Oh well...

...240 days, 400 posts ==> Forum Guru

Unfortunnately this is not correct. Where did you read this? True is that, normally,you have to wait 672 days for this

672 days.... Okie.. I will be contented to be able to have upload my avatar...