Auto sum?

On 04/09/2004 7:11 AM, in article
jemcgimpsey-CAC211.08114509042004.RemoveThis@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey.RemoveThis@mvps.org> opined:

 > In article <BC9B1463.5AB98%elvispmpsd@compuserve.net>,
 > The Wolf <elvispmpsd.RemoveThis@compuserve.net> wrote:
 >
  >> If I want the mileage for a month it would subtract the smaller from the
  >> larger number, opposite of sum.
  >>
  >> Is there a way to do this automatically? I am putting a formula in a cell
  >> manually. But there will be more entries for the month. Can this be updated
  >> automatically?
 >
 > It certainly can, in a variety of ways, but it's not clear from your
 > description what the layout of your data is.
 >
 > Post back with a detailed description and we can help you. Thing to
 > include:
 >
 > are your mileages entered in rows? columns?

Columns, imported from Palm application Highway Manager

is each row/column a
 > complete record, or is data grouped in some other way? Do you want the
 > mileage to be calculated for each row/column


For a column b1,b2,b3, etc.

Here's the rub, The data is imported into the main sheet. I made separate
sheets for Jan, Feb, March, etc. So there will be more entries in the April
sheet as the month progresses, that's why I want it done automatically.

Sorry if this is not clear, I don't have a great deal of experience.

or in one cell only?<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Auto sum? 

In article <BC9C27DC.5AE12%elvispmpsd@compuserve.net>,
The Wolf <elvispmpsd DeleteThis @compuserve.net> wrote:

  > > are your mileages entered in rows? columns?
 >
 > Columns, imported from Palm application Highway Manager
 >
 > is each row/column a
  > > complete record, or is data grouped in some other way? Do you want the
  > > mileage to be calculated for each row/column
 >
 >
 > For a column b1,b2,b3, etc.
 >
 > Here's the rub, The data is imported into the main sheet. I made separate
 > sheets for Jan, Feb, March, etc. So there will be more entries in the April
 > sheet as the month progresses, that's why I want it done automatically.
 >
 > Sorry if this is not clear, I don't have a great deal of experience.
 >
 > or in one cell only?

One way:

=IF(B1<>"", INDEX(B:B,COUNT(B:B))-B1, "")<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Auto sum? 

On 04/09/2004 4:40 PM, in article
jemcgimpsey-539D44.17405509042004.TakeThisOut@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey.TakeThisOut@mvps.org> opined:

 > In article <BC9C27DC.5AE12%elvispmpsd@compuserve.net>,
 > The Wolf <elvispmpsd.TakeThisOut@compuserve.net> wrote:
 >
   >>> are your mileages entered in rows? columns?
  >>
  >> Columns, imported from Palm application Highway Manager
  >>
  >> is each row/column a
   >>> complete record, or is data grouped in some other way? Do you want the
   >>> mileage to be calculated for each row/column
  >>
  >>
  >> For a column b1,b2,b3, etc.
  >>
  >> Here's the rub, The data is imported into the main sheet. I made separate
  >> sheets for Jan, Feb, March, etc. So there will be more entries in the April
  >> sheet as the month progresses, that's why I want it done automatically.
  >>
  >> Sorry if this is not clear, I don't have a great deal of experience.
  >>
  >> or in one cell only?
 >
 > One way:
 >
 > =IF(B1<>"", INDEX(B:B,COUNT(B:B))-B1, "")

Was I suppose to literally cut and paste this? Or due something with the B:B
part?

It didn't work, is there another way?<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Auto sum? 

In article <BC9C9EC0.5AE26%elvispmpsd@compuserve.net>,
The Wolf <elvispmpsd.TakeThisOut@compuserve.net> wrote:

 > Was I suppose to literally cut and paste this? Or due something with the B:B
 > part?
 >

Yes, cutting and pasting should work.

 > It didn't work, is there another way?

Unfortunately, "It didn't work" is a singularly unhelpful statement.
What does that mean to you? Did you get an error? did you get the wrong
result? did XL crash?

based on your description, it *should* work, but there are several
things that could cause problems. Without knowing more about what
"doesn't work", it's impossible to diagnose.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Auto sum?