Subtotal function (used in tables) what is the function num?
I frequently use little tables, particularly to format data in preparation for sending in an email.
I just needed to add a subtotal row, and saw I could check "subtotal" as one of the options for the table.
It added just one aggregate figure, and it had a formula like this:
It was doing a count of rows, not a SUM as I wanted. Looking into it,
103 was described as a function number. (This is not peak-lambda).
What is the function number for SUM ? Use this handy table!
|Function||Include hidden||Ignore hidden|
COUNTA is different from
COUNTA only counts "non-blank" values.