How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel?
The following should work for this case:
=SUM(B1:B10) - SUM(A1:A10)
The following should work for this case:
=SUM(B1:B10) - SUM(A1:A10)