Forum Discussion
Solved
SUM between empty cells
Hello, I would like to ask for advice. I have the data in the column, see picture. How to automatically sum data that is between empty cells? i.e. SUMA(A1:A2); SUMA(A6:A9) ..... Thank you ...
tomaspet If you ae on and Excel version that support XMATCH, have a look at the attached file, using the following formula:
=IF(AND(ISBLANK(A1),NOT(ISBLANK(A2))),SUM(A2:INDEX(A2:$A$46,XMATCH(,A2:$A$46,0))),"")
tomaspet If you ae on and Excel version that support XMATCH, have a look at the attached file, using the following formula:
=IF(AND(ISBLANK(A1),NOT(ISBLANK(A2))),SUM(A2:INDEX(A2:$A$46,XMATCH(,A2:$A$46,0))),"")
Riny_van_Eekelen I tried it in Excel online and everything works. Thank you.