I'm trying to track my recent 12 months spend on an ongoing basis. Each month a new column is added for the new month, but I want Column B to show the sum of the most recent 12 months.
I've set up a sheet that can be edited at https://docs.google.com/spreadsheets/d/1GNAyLuRHDXJYpCndVIIovIB4_Y-QXgH2nOMn1OSNTVc/edit?usp=sharing
The formula that I've tried in cell B2 is (not working):
=SUM(QUERY(SORT(C2:AZ2, Column(C2:AZ2)*ISNUMBER(C2:AZ2), 0), "select * limit 12"))