Excel Table formatting

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.