Forum Discussion
difference between two columns
is there a simple formula i can add and use to calculate the difference in value of two columns showing percentage and actual difference? excel
You can calculate the difference between the columns with e.g. =SUM(A1:A100)-SUM(B1:B100). And you can divide that by whichever basis column you please to get the percentage difference - e.g. (SUM(A1:A100) - SUM(B1:B100))/SUM(A1:A100)