Formulas to apply using excel to track utility usage

Formulas to apply using excel to track utility usage

Hello Hailey,

Understandably you are trying to create a formula that will track the summary of your utilities. You can try summing up your data by dragging the first column/row unto the last cell portion of the column/row and then left click the Auto-Sum on your homepage of excel. You can also use a formula by typing =sum( then highlight the columns/row you want to add then type ) and enter. If you are trying to track data from different spreadsheet, type = then left click the data you want to add, type + and left click the data from another spreadsheet and click enter. You can always create a formula in summing up or subtracting the data from the column/row in the spreadsheet by using the first formula to type which is the equals sign (=) then use the normal signs in calculating your data. 

Cole Lung