Hi, I am trying to find the last entry of a column, in order to add /
subtract from other sums. Is there a way to do this? the work-around using
is:

using a work column: =IF($G5="",$G4,0)
and entering 0 in unused rows, then can use: SUM(H4:H26)-$O$30
can I replace that with something else, and get rid of the work column?
thanks

=sum(H4:H26)-=LOOKUP(10^10,G:G)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"nastech" wrote in message
...
Hi, I am trying to find the last entry of a column, in order to add /
subtract from other sums. Is there a way to do this? the work-around
using
is:

using a work column: =IF($G5="",$G4,0)
and entering 0 in unused rows, then can use: SUM(H4:H26)-$O$30
can I replace that with something else, and get rid of the work column?
thanks

Hello

see he

http://www.mvps.org/dmcritchie/excel...l.htm#formulas

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"nastech" wrote:

Hi, I am trying to find the last entry of a column, in order to add /
subtract from other sums. Is there a way to do this? the work-around using
is:

using a work column: =IF($G5="",$G4,0)
and entering 0 in unused rows, then can use: SUM(H4:H26)-$O$30
can I replace that with something else, and get rid of the work column?
thanks

That should say

=SUM(H4:H26)-LOOKUP(10^10,G:G)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bob Phillips" wrote in message
...
=sum(H4:H26)-=LOOKUP(10^10,G:G)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"nastech" wrote in message
...
Hi, I am trying to find the last entry of a column, in order to add /
subtract from other sums. Is there a way to do this? the work-around
using
is:

using a work column: =IF($G5="",$G4,0)
and entering 0 in unused rows, then can use: SUM(H4:H26)-$O$30
can I replace that with something else, and get rid of the work column?
thanks

thanks, what is result, tried, but did not test, did no quite get last item
in column, suspect a SUM of sorts, else item works: thanks

=LOOKUP(9.99999999999999E+307,$G$4:$G$27)

note: column H is where work cells/column are, attempting to delete to make
less volatile / dependant / space taking



"Bob Phillips" wrote:

That should say

=SUM(H4:H26)-LOOKUP(10^10,G:G)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bob Phillips" wrote in message
...
=sum(H4:H26)-=LOOKUP(10^10,G:G)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"nastech" wrote in message
...
Hi, I am trying to find the last entry of a column, in order to add /
subtract from other sums. Is there a way to do this? the work-around
using
is:

using a work column: =IF($G5="",$G4,0)
and entering 0 in unused rows, then can use: SUM(H4:H26)-$O$30
can I replace that with something else, and get rid of the work column?
thanks