Type of SUM formula ???

[Guest]

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

 

[Bob Phillips]

=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)

 

[Guest]

Hello

see here:

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

 

[Bob Phillips]

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)

 

[Guest]

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