Comparing not associated columns

[MWiciok]

Hi all,

I've got a question concerning comparing expressions of not associated columns. My set up looks like this:

Table1:

Column1	Column2
A	1
B	2
C	3

Table2:

Column3	Column4
A	1
A	1
B	2
C	1
C	2
D	3
E	4

Now I want to calculate, how often the sum of Column4 grouped by Column3 equals the value in Column2. I got something like

=count(Column1 = aggr(Column3,Column1))

this gets me the number of sets of Column1 which are also in Column3. But I want to get a step further and expand this expression by comparing the sums of Column2 and Column4.

Do you know what I mean? Can you please help me?

Oh, I want these columns not to be associated....

Thanks in advance

[Anonymous]

Hi Matthias,

See attached if this is what you want.

Regards,

Michael

[MWiciok · Accepted solution]

Well, this is the right direction. But I want to count the Yes-Rows.

I solved this matter by creating a new table and there store the values. See attached file for this.