I've got a column of numbers from which I'd like to calculate the sum of top ten biggest numbers, with addition to another criteria.
The criteria setup is something like this:
criteria1 | criteria2
"value" | =A1>LARGE(A1:A100;9)
The "value" criteria affects the DSUM-function correctly, without the criteria2 the sum is right. But with the criteria2, the sum is 0. That is, the DSUM does not find any field to match the criteria2. How the criteria2 should be written? As a formula like above or something like ="=A1>LARGE(A1:A100;9)" or something else?
The criteria setup is something like this:
criteria1 | criteria2
"value" | =A1>LARGE(A1:A100;9)
The "value" criteria affects the DSUM-function correctly, without the criteria2 the sum is right. But with the criteria2, the sum is 0. That is, the DSUM does not find any field to match the criteria2. How the criteria2 should be written? As a formula like above or something like ="=A1>LARGE(A1:A100;9)" or something else?