adding up a column from another sheet

[JoJo2Fast]

Hi all, I apologize if this has been posted before but I'm just looking for a quick answer. I'm trying to build a spreadsheet for my photography business with all my revenues and expenses and so on. Anyways I have one sheet made with payments and client info and on another sheet I have my financial expenses and revenues. I'm trying to add, for example, the entire G column so that when I post new client info into the spreadsheet, it will automatically update in my financial sheet. When I try to click on the G, it selects the all of the cells that have info in them. Any help would be greatly appreciated, thanks!

[tony h]

The total of column G on sheet Income is =sum(Income!G:G)

[Palmetto]

It is generally not efficient to reference an entire column of cells, thus it is best not to use G:G.

since you are using Excel 2007, you should consider converting the client info/payments sheet into a table. There are benefits to this approach: Excel automatically carries all formatting forward to new entries and you can reference the table header in a simple, easy to understand formula, such as:

=SUM(Table1[Payment])

Where "Table1" is the name of the table you created and "Payment" is the column in the table who values you want to sum.

To convert the existing data into a Table, select all of the cells, then on the Insert tab (ribbon menu) click on Table.


Two other options to consider:
Create a dynamic named range for the column of values and use this named range in the sum formula. The dynamic named range automaticallty exands to include new rows of data. Such a formula might look like:

=Sum(Payments)

Where "Payments" is the name given to the dynamic named range of values.

Or use a Pivot Table based on a dynamic named range.

See attached example for Table and summing dynamic named range.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Edited this time