

March 16, 2015

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!!

VIP

Trusted Members

June 25, 2016

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


March 16, 2015

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!!!

VIP

Trusted Members

June 25, 2016

1 Guest(s)
