I have an excel table ("lstTestSource") like this:
I have a second excel table ("lstTestResult"), which evaluates the first one:
There is a formula in each row in the second column ("lstTestResult"):
=SUMPRODUCT((lstTestSource[Color]=[@Color])*(SUBTOTAL(109; OFFSET(lstTestSource[[#Kopfzeilen];[Amount]]; ROW(lstTestSource[Amount])-ROW(lstTestSource[#Kopfzeilen]); 0))))
The formula is accurate; I can filter by "lstTestSource" and the results will display the correct values in the rows.
A result row appears at the conclusion of "lstTestResult," and no matter what filter is in effect, the result is always 0. There, too, I want to use the SUBTOTAL method.
The automatic calculation is turned on.
I looked into this issue on Google, but I was unable to locate any solutions. Can someone please help me with this?