Brittney1313
New Member
- Joined
- Jun 12, 2016
- Messages
- 8
Hello,
I am trying to figure out how sum up two different functions into one cell. I have figured out the initial formula to sum the functions, I am using an array formula with the sum nested, however, I cannot figure out how to get just the one functions answer to populate if the second function does not exist for that particular column.
The two functions I am using are 1) Index&Match to populate one set of numbers that exist on another sheet based on a name, and 2) the vlookup function to lookup another set of numbers that exist on another separate sheet based on a name. The function I have sums both of these numbers but it only works when both names exist on both separate sheets. I would like to implement a formula that adds the two when they both exist, and also only lists the one item that exists if the second does not (the index&match has a number to populate, but the vlookup does not have that name on that sheet to populate a number)
Should i be using something other than Sum? I could not figure out if i am able to use a SumIF in this situation, as sometimes there are numbers in both sets of functions, and sometimes only 1 set of the functions has a number, and sometimes none of them will populate a number as the name is not listed in either separate sheet.
Basically the formula is something like this =iferror(sum(iferror(index"SHEETNAME", MATCH(SHEETNAME,0))," "), VLOOKUP(SHEETNAME,False))," ")
Again like i said it only works if both the indexmatch and vlookup exist, it will not populate just one of the values if there is one only.
Any help would be greatly appreciated. Thank so much.
I am trying to figure out how sum up two different functions into one cell. I have figured out the initial formula to sum the functions, I am using an array formula with the sum nested, however, I cannot figure out how to get just the one functions answer to populate if the second function does not exist for that particular column.
The two functions I am using are 1) Index&Match to populate one set of numbers that exist on another sheet based on a name, and 2) the vlookup function to lookup another set of numbers that exist on another separate sheet based on a name. The function I have sums both of these numbers but it only works when both names exist on both separate sheets. I would like to implement a formula that adds the two when they both exist, and also only lists the one item that exists if the second does not (the index&match has a number to populate, but the vlookup does not have that name on that sheet to populate a number)
Should i be using something other than Sum? I could not figure out if i am able to use a SumIF in this situation, as sometimes there are numbers in both sets of functions, and sometimes only 1 set of the functions has a number, and sometimes none of them will populate a number as the name is not listed in either separate sheet.
Basically the formula is something like this =iferror(sum(iferror(index"SHEETNAME", MATCH(SHEETNAME,0))," "), VLOOKUP(SHEETNAME,False))," ")
Again like i said it only works if both the indexmatch and vlookup exist, it will not populate just one of the values if there is one only.
Any help would be greatly appreciated. Thank so much.
