I wish it was just that easy. My spreadsheet is about 10,000 rows and I was
searching for one formula that I could use.

"TomPl" wrote:

I may have misunderstood your question but it should be as simple as entering
the following formulas:

Enter the formula =sum(C2:C5) in cell C6
Enter the formula =sum(C9:C14) in cell C15

Tom