can't add rows of data dictate by a number in a cell

Hello everyone. I am new to the forum and hope someone can help me with this. I am trying to add multiple rows of data base on a number I put in a cell. For example, in cell C1(this is where I put the number of rows I want to add), I put 2. In Cell B1, it will add Cell A1+A2. If I change the number in C1 to let's say 3, in Cell B1, it will add Cell A1+A2+A3. I tried to look up formulas in excel but was unsuccessful. I assume I have to write some VBA (which I am a newbie to this). Greatly appreciated to anyone that can help. Thanks.