Hi all. I have a spreadsheet that needs a subtotal of values below a blank cell. Is there a single formula that I could use to get the subtotals by filtering the cells where the subtotals are and pressing Ctrl+Enter? I would like to use =SUBTOTAL(109) instead of the SUM function to get the totals.
Attached is a sample table. The real table contains around 3,800 subtotals.
Thank you.

Attached Files

Sum Below Blank Cell.xlsx (11.0 KB, 13 views)