Writing formulas

[Rowdy]

how to create a formula that auto fills and increments adding each additional line to the formula? IE =sum(e2:e3)+(f2:f3)
=sum(e2:e4)+(f2:f4) . . . . . . ? I know I’m probably posting in the wrong place.

[robleyd]

Your syntax is wrong there; you need to include both ranges in the SUM arguments.
=SUM(e2:e3;f2:f3)

If I understand your problem correctly you need an absolute reference for the first element in each range to sum.

Basics of Relative, Absolute and Mixed Reference in Calc

If this doesn’t help, please give a little more detail on exactly what you are trying to achieve.

[Zizi64]

=SUM(e2:e3;f2:f3)
.

This is equivalent to:
=SUM(E2:F3) in this case (adjacent ranges with same size)

[karolus]

@Rowdy

that auto fills and increments adding each additional line to the formula? IE =sum(e2:e3)+(f2:f3)
=sum(e2:e4)+(f2:f4)

Start with Formula:

=SUM($E$2:F3)

and fill down