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