Excel Table formatting

Or, if you mean it has a line break in a single cell:  =SUM(--TEXTSPLIT(A1,CHAR(10)))

• CHAR(10) = line break character
• TEXTSPLIT() splits the cell into an array. An example might be [10|20] but the pipe is the line break
• "--" converts the array text to numbers

I think, Riny_van_Eekelen​ , that the original poster didn't mean to add rows, just to add the values in multiple lines of a given column. That said, the question was entirely ambiguous, so your request for clarification is still on point.

Lata1976​ If you're not able to post your file, you do need to ask your question with a bit more clarity of intention. For example, if you just want to add contiguous rows in a column, then the generic SUM function is what you need. If, on the other hand, you want to add the figures that correspond to a label or text in a different column.--eg, add all expenses that are "Food" in an adjacent column--then the SUMIF function would be useful. There are several other variations on these....I give those two possibles just to get you started.

Formulas don't add rows to Excel Tables! So, please be more specific and explain what you are trying to achieve. Share a link that gives access to your file, upload screenshots. Anything that clarifies your intentions.