If I have to calculate say discounts to be given to customers based on sales
for various brands every month, is there a way I could automate this process?
Currently I run the report to an excel output file but then it is all manual
process of inputting the sales data to a spreadsheet which has the formulas
allready put?

Thanks

Most likely. As you didn't provide details though as to data layout, or what
exactly your are analysing, our input is limited. Some starter functions that
might be of use:

SUMIF, COUNTIF, VLOOKUP

SUMPRODUCT might also be of use, but is a little more complex. Try searching
these forums for ideas/examples on how this is used.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeevan" wrote:

If I have to calculate say discounts to be given to customers based on sales
for various brands every month, is there a way I could automate this process?
Currently I run the report to an excel output file but then it is all manual
process of inputting the sales data to a spreadsheet which has the formulas
allready put?

Thanks