I am using nPrinting formula to calculate sum of sales. My data looks like below.
|1 - jun||1-May|
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.