Total row

Summary

In this video we look at how to add a total row to the bottom of the FILTER result.

Tab in example file: Total row

Combining LET, HSTACK, CHOOSECOLS and VSTACK we can add a total row to the bottom of FILTER.

To format the total row we use conditional formatting applied to a range which is large enough to include the maximum size which the result could occupy.