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.
