I am using Datalink to summarize data from a 2D matrix to a multi-dimensional table. However, some of the columns are not summarizing for me. They are real numbers (not integers), there are no errors or blanks in the column. They are involved in formulae, but despite multiplying by 1, using value() etc, they still won’t sum for for me in the multi-d table.
One clue: when I use CountA instead of SUM or COUNT, then it does work.
Has anyone observed this behaviour? I want to avoid having to write formulae to deal with this.