Adding info from One column of a sheet to the column of another sheet

Vinton Douglas

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.

Paul Newcome

I personally would suggest using cell linking to pull the cells from the 1st two sheets into the 3rd sheet and then sum those.

Antonio Figueroa

I would try using sumifs.

Dale Murphy

@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

Vinton Douglas

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).

Shift 1.png

Shift 2.png

Paul Newcome

I personally would suggest using cell linking to pull the cells from the 1st two sheets into the 3rd sheet and then sum those.

Vinton Douglas

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.

Paul Newcome

Happy to help. 👍️