Hi All!

This is my first post/thread in this forum.

I have a problem figuring out how to convert a text formula to something readable in Excel.
Here are the details:

I have many rows that have a specific identification value designated at column A.
If I want to add all these lines I use SUMIF formula to add all the rows' specific cell. This totalling row has value A1.

The real problem is when I have another line where I want to add two or more different totalling lines like the one above. I want to read a formula A1+A2+A3...+An

So my question is how do I split the formula A1+A2+A3...+An so Excel can recognise that I want to sum up cells A1, A2, A3..An?

Thanks in advance!