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!!
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
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!!!
Hi Elinor
Give me some sample and I will try and see what I can do. Hope it is a tabular format.
Sunny
please check the attachment, hope it is what you want.
I deleted some numbers in column B which are not Date.
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...