Formulas to apply using excel to track utility usage

Asked By Hailey Malles 0 points N/A Posted on - 05/06/2013

Hi Everyone,

What formulas can I apply using excel to track utility usage? I badly  need your help.

Thanks,

Hailey

• Status: Open
• Question Views: 836
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Cole Lung 0 points N/A #176424

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

About Cole Lung

Questions
3

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/06/2013
• Question Category: MS Excel