Hi Guys,
I am using nPrinting formula to calculate sum of sales. My data looks like below.
Product
| 1 - jun | 1-May |
|---|
| Printers | 5 | 8 |
| Scanner | 9 | 2 |
My formula looks like =Sum(1-jun) and =sum(1-May). Now it give me the correct values but whenever there is change in the column headers, i am not getting the results as expected. Suppose 1-jun changes to 1-July and 1-May changes to 1-jun.
How to use formulas in this kind of situation. Let me know if you need any other details.
Regards,
Viresh
