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 it on the list of options for the table. It added just one aggregate figure, and it had a formaula like this:
I 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|
Note that COUNTA is different from COUNT, because COUNTA only counts "non-blank" values.