|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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" <bob.ngs@somewhere.com> wrote in message
news:evPf$PJyHHA.988@TK2MSFTNGP02.phx.gbl...
> =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" <nastech@discussions.microsoft.com> wrote in message
> news:CA748492-C52C-471D-A1BD-DF2AA0F0E5A0@microsoft.com...
>> 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
>
>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
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" <bob.ngs@somewhere.com> wrote in message
> news:evPf$PJyHHA.988@TK2MSFTNGP02.phx.gbl...
> > =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" <nastech@discussions.microsoft.com> wrote in message
> > news:CA748492-C52C-471D-A1BD-DF2AA0F0E5A0@microsoft.com...
> >> 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
> >
> >
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Answer
Notify me of replies