Forum Discussion
Solved
Sum of values if identifier matches
Good day, everyone! I have two tables that provide information to each other. Please see the example below before I proceed explaining. TABLE 1 Item Code Total Code A 2000 (1000 + 10...
The content in red is the obvious math. It doesn't actually show up in the cell at all. That's what I was trying to explain in the 2nd to last paragraph. The number in black is the actual result that shows up in the cell; it is the sum of the two values in red (in table 1).
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?
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.
- I actually went back and figured out what was causing the issue. I made my original document return literally a 0 rather than a blank. Now it gets registered as a numerical value.
Thank you so much for this!