Thanks for the information. However, I want the default behaviour to be SUM
or AVERAGE, but I'm getting COUNT, even though all the data I'm dragging is
numeric (the result of a calculation on another worksheet in the workbook,
linked by Paste Link).
You have at least one empty/blank/non-numeric cell in that field, else you would
have seen Sum. (Maybe the range includes an extra row at the bottom???)
And when you find a way to change this behavior, please post back.
Ken said:
Thanks for the information. However, I want the default behaviour to be SUM
or AVERAGE, but I'm getting COUNT, even though all the data I'm dragging is
numeric (the result of a calculation on another worksheet in the workbook,
linked by Paste Link).
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.