writing help: how do I write a formula that will populate the sum into another worksheet w/o linking? - Help.com

aliciadhowar
offline Verified (1 year, 2 months) Visit aliciadhowar's shoutbox
An Unknown Location

how do I write a formula that will populate the sum into another worksheet w/o linking?

I have a master-sheet linked w/several worksheets. I need various subtotals o/the worksheets to populate into one cell of the master with continuous addition.

This open post was written 1 year ago | V/U/S: 117, 1, 2 | Edit Post | Leave a reply | Report Post


Reciprocity (0) Reciprocation Failure -- The poster has NOT helped anyone else yet!

Since writing this post aliciadhowar may have helped people, but has not within the last 4 days. aliciadhowar is a verified member, has been around for 1 year, 2 months and has 2 posts and 0 replies to their name.

Post Tags (13)

Addition, writing, Summation, master, Cell, Formula, Continuity, Into Another, Worksheet, sheet, advance excel formula, formulas, excel (How Tags Affect Reciprocity)

Replies (1)

Where were you?

Click and drag to move the map around. FAQ: How we place people on this map »
You can also watch events on Help.com as they happen
Mouse over the map for 2 seconds to see an expanded, interactive view

MicroVB INC offline Verified User (1 year) Long Term User Shouts: 1 #
An Unknown Location | 1 year ago (1 day, 4 hours after post)

If you add all the worksheets into a workbook, it is pretty simple from there on…

Suppose one of your worksheets is “Cost”

In the Field on another worksheet to get the sum of A1 to A100, you would do this

=Sum(’Cost’!A1:A100)

Quote this reply Report this reply to moderators

Invite Others to Help

A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.