Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I need to use SUM formula to fill the Total formula until next Total comes in Google Sheets like this:
paste in B1, B5, etc. where you need...
=SUM(INDIRECT(ADDRESS(ROW()+1; 2; 4)&":"&ADDRESS(IFERROR(MATCH("TOTAL";
INDIRECT(ADDRESS(ROW()+1; 1; 4)&":A"); 0)+ROW()-1; ROWS(A:A)); 1; 4)))
Required, but never shown