sum at 3 rows below dynamic range

[dave h]

HI

i have a dynamic range created with

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A$1:$A$100),COUNTA(Sheet1!$1:$1))

and i want to sum the values in column c with the sum 3 rows below the end
of the dynamic range

how do i do this?

 

[Dave Peterson]

I'd just use the same criteria, but apply it to column C:

either another defined name using this formula:
=OFFSET(Sheet1!$C$1,0,0,COUNTA(Sheet1!$A$1:$A$100)+3,1)

or
=SUM(OFFSET(Sheet1!$C$1,0,0,COUNTA(Sheet1!$A$1:$A$100)+3,1))

 

[dave h]

thanks ever so much

I'd just use the same criteria, but apply it to column C:

either another defined name using this formula:
=OFFSET(Sheet1!$C$1,0,0,COUNTA(Sheet1!$A$1:$A$100)+3,1)

or
=SUM(OFFSET(Sheet1!$C$1,0,0,COUNTA(Sheet1!$A$1:$A$100)+3,1))