Type of SUM formula ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

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