I am trying to use SUMIF to sum a number of items on one tab into one cell on the other.
I have a cell with a three series of numbers in one cell. In that same row, next cell, I would like to return values from another sheet which are in different rows.:
Sheet 1:
Column A column C
----------- ------------
Row 1 887989
987677 ????Formula????
876663 (all in one cell )
Sheet 2:
Column A Column B
----------- -----------
row 1 887989 1
row 2 987677 4
row 3 876663 3
Ideally, I would like that formula to return 8 as the answer.
I have a cell with a three series of numbers in one cell. In that same row, next cell, I would like to return values from another sheet which are in different rows.:
Sheet 1:
Column A column C
----------- ------------
Row 1 887989
987677 ????Formula????
876663 (all in one cell )
Sheet 2:
Column A Column B
----------- -----------
row 1 887989 1
row 2 987677 4
row 3 876663 3
Ideally, I would like that formula to return 8 as the answer.