Hi,
Have two tables, want to add column in table 1 based on SUM from a column in table 2.
The column must SUMIFS like excel based on the same row in table 1 and columns in table 2.
Like SUMIFS(Result Column Table 2, Column 1 in Table 2 = value in row in Column 1 in table 1, Column 2 in Table 2 = value in row in Column 2 in table 1, Column 3 in Table 2 = value in row in Column 3 in table 1)
So it sums the column from table 2 based on only the rows where these three matches,
So on the row it sums if the Date matches, the Unit matches and the Name matches. A normal SUMIFS with different tables.
Have tried SUMX, Calculate with SUM and filters but can't get it right. Closest is that it equals a specific value, but I want it to equal the value in the row.
Could you please help me solve this?
Thanks!
