This video is a clip from a live followup Q&A meeting after one of my webinars, where I explain how to write a macro to create SUBTOTAL formulas in Excel. I briefly explain how to find the last used cell in a range, and then place the formula in a cell below the last used cell.
Download the file that contains the SUBTOTAL Metrics Macro at the following link: https://www.excelcampus.com/vba/subtotal-metrics-macro/