Adding info from One column of a sheet to the column of another sheet
I am collecting info at 2 different times from different individuals on two different sheets. How can I add input from one column of one sheet to the column of another sheet? I will then use the info to populate a dashboard. Any help would be grateful. Or any other work around.
Best Answer
-
I personally would suggest using cell linking to pull the cells from the 1st two sheets into the 3rd sheet and then sum those.
Answers
-
I would try using sumifs.
-
@Vinton Douglas Are you familiar with Index() or Collect() ? Almost any function that evaluates a range can evaluate a range from a different sheet. If you want to insert a cell from somewhere else, but have it match to a column in your current sheet, Index with an embedded Collect or Match clause will get you there.
Here is one I use:
=IFERROR(IF(ISBLANK(Store@row), "No Name", INDEX({Address Matrix local Range 1}, MATCH(Store@row, {Address Matrix local Range 2}, 0), 3)), "Store not found")
The swirly brackets indicate a range from a different sheet. This formula checks a remote sheet for a row where the store matches the value in the equivalent column in the local sheet. When it matches, it retrieves "Range 1" from the remote sheet and inserts it into the local column.
dm
-
Thanks Dale,
I am not familiar with the method you suggested as I am still learning the basics. Could you be kind enough to say how this would translate to a column (Called 3) of a new worksheet if I am trying to sum the columns from 2 separate worksheets attached (shift 1 and Shift 2) which are from 2 different worksheets. So cell in column 3 of a different worksheet=Sum of cell in shift 1 (different sheet) + cell in Shift 2 (different sheet).
-
I personally would suggest using cell linking to pull the cells from the 1st two sheets into the 3rd sheet and then sum those.
-
Thanks both,
Both approaches are new to me. I am still looking into Index() and Collect() . I tried cell linking and found it to be helpful. Your suggestions are much appreciated.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!