Forum Discussion
Sum of values if identifier matches
I can't speak for others, but speaking for myself, I fail to see the logic that would, based on some kind of lookup of the entries in the first column of Table 2, yield the results in the second.
It seems to me that you may be making assumptions about how this is working, assuming that those assumptions are obvious, but if you really expect to have a clear answer--i.e., a clear formula that is based on functions--then the whole situation needs to be explained more fully.
Does the second column of table one, for one thing, actually contain those numbers shown in red, or are you showing us the obvious math (except for Code C, where it dosn't work). And, given Code C's confusing components, what is the consistent relationship between the number in black and the two in red?
Your example, in short, is hard to reverse engineer. So help us help you by explaining things more clearly.
For example. Code C shows up twice in table 2: once with a value of 1000 and once with a value of 5000. Therefore, 5000 + 1000 = 6000. The 6000 is the actual value that I need to be shown in the second column of the first table.
Anything else I should clear up?
Sorry for the long delay. I was testing it out on my actual table and getting a #VALUE! error.
Is there a way to make it ignore the blanks that will definitely sometimes show up in the Units column in the second table?
Can you give an example of your actual database? In the attached sample file i've added blanks in the Units column of the second table and the formula works as intended.