Can any one help me resolve this issue?
I would like in Cell G5 for instance insert a formula that will rollup all
values beneath until last non empty Cell and generate that formula based on
the range found within the same column.

I found one related issue in the Forum but I tried to rollup the amount and
generate the Formula and I could not.

Your help will be very appreciated.

Thanks in advance!

Chuck

=sum(offset("G5",0,0,counta("G5:G65000"),1)

Thanks Brian! but it is giving me an error.
It Says the Formula you typed contains an error.
I could not figure out where is the error?

Thanks!

"Brian Taylor" wrote:

=sum(offset("G5",0,0,counta("G5:G65000"),1)

Brain meant =sum(offset("G5",0,0,counta("G5:G65000"),1))

that is almost what he meant. what he really meant was probably more like:

=sum(offset(G5,0,0,counta(G5:G65000),1))

--
Regards,
Tom Ogilvy


"GregR" wrote:

Brain meant =sum(offset("G5",0,0,counta("G5:G65000"),1))

Sorry. I don't know why I put quotes in there.

One way:

=SUM(G6:INDEX(G6:G1000,MATCH(FALSE,ISNUMBER(G6:G10 00),0)))

Array-entered, meaning after inserting the formula into G5, press ctrl +
shift + enter. Excel will place {} around the formula.

Change G1000 if needed.

HTH
Jason
Atlanta, GA

"Chuck H." wrote:

Can any one help me resolve this issue?
I would like in Cell G5 for instance insert a formula that will rollup all
values beneath until last non empty Cell and generate that formula based on
the range found within the same column.

I found one related issue in the Forum but I tried to rollup the amount and
generate the Formula and I could not.

Your help will be very appreciated.

Thanks in advance!

Chuck

Thanks fellows! I have found that by removing the double quote and use the
formula as Brian provided, the formula works fine but have changed it as
below:
=SUM(OFFSET(G6,0,0,COUNTA(G6:G65000),1))
And this works perfectly.

Thank you very much to all!

Have a great weekend!

Chuck

"Jason Morin" wrote:

One way:

=SUM(G6:INDEX(G6:G1000,MATCH(FALSE,ISNUMBER(G6:G10 00),0)))

Array-entered, meaning after inserting the formula into G5, press ctrl +
shift + enter. Excel will place {} around the formula.

Change G1000 if needed.

HTH
Jason
Atlanta, GA

"Chuck H." wrote:

Can any one help me resolve this issue?
I would like in Cell G5 for instance insert a formula that will rollup all
values beneath until last non empty Cell and generate that formula based on
the range found within the same column.

I found one related issue in the Forum but I tried to rollup the amount and
generate the Formula and I could not.

Your help will be very appreciated.

Thanks in advance!

Chuck