Forum

Notifications
Clear all

Getting the Total Sales per salesperson per month

6 Posts
3 Users
0 Reactions
164 Views
(@elicozeac)
Posts: 18
Eminent Member
Topic starter
 

good day everyone,

please help me solve my problem regarding the computation of sales per salesperson and per month.

please check the attach file for my data.

Thank you very much and God bless!!

 
Posted : 07/02/2018 9:17 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Elinor

I am unable to use any formulas to compute the result you wanted as the format of your raw data is not suitable.

You should ensure that your data is in a tabular format. That will allow you to easily analyze your data using formulas or Pivot Tables.

In this situation, I have to use VBA. Just click the button to compute the result.

Hope this helps.

Sunny

 
Posted : 07/02/2018 10:23 pm
(@elicozeac)
Posts: 18
Eminent Member
Topic starter
 

Hello Mr. Sunny,

thanks for your reply

how about if i will compute the daily sales of each salesperson, can you help me find solution for that. And also i can not change the format of my raw data because i exported this from our system. My manager require me to report to him daily the daily sales of each salesperson.

Thank you and God bless!!!

 
Posted : 08/02/2018 2:17 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Elinor

Give me some sample and I will try and see what I can do. Hope it is a tabular format.

Sunny

 
Posted : 08/02/2018 2:21 am
(@shaowu459)
Posts: 44
Eminent Member
 

please check the attachment, hope it is what you want.

I deleted some numbers in column B which are not Date.

 
Posted : 08/02/2018 2:32 am
(@elicozeac)
Posts: 18
Eminent Member
Topic starter
 

Good day,

Thank you Sirs Sunny and Clark for your quick reply. And thank you for the solutions you shared, I already solve my problem and ready for sending daily report to management. God Bless you and your team...

 
Posted : 08/02/2018 10:05 am
Share: