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))),"")
6 Replies
tomaspetBasked on what I see in the picture, you could just use =SUMA(A1:A23)
Riny_van_Eekelen I couldn't do that. I need to get this (red numbers), but I need to fill in automatically because there are many rows in the table.
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))),"")
