Hi, I wonder if anyone can help me. I am trying to create a spreadsheet in
microsoft works. I need the formula for a column to add up balances. i.e.
amount sub paid balance
collected total out
5.00 5.00 5.00
6.40 ? 3.00 ?

How would I formulate the subtotal column & the balance column to add up
running totals, or do I have to formulate each cell seperatley, cos that
would take forever & I might just as well add up in my head & type in the
answer. Any help would be much appreciated,
Thanks

amnt sub paid balance
> A B C D
> 1 5 =A1 X =B1-C1
> 2
> 3
>
> Drag down on each cell to replicate it's formula into the cell
> below

rgds
Robert


> "chris" <chris@discussions.microsoft.com> wrote in message
> news:C1B0C37C-B784-4549-A587-8D2CCB432496@microsoft.com...
>> Hi, I wonder if anyone can help me. I am trying to create a spreadsheet
>> in
>> microsoft works. I need the formula for a column to add up balances. i.e.
>> amount sub paid
>> balance
>> collected total out
>> 5.00 5.00
>> 5.00
>> 6.40 ? 3.00
>> ?
>>
>> How would I formulate the subtotal column & the balance column to add up
>> running totals, or do I have to formulate each cell seperatley, cos that
>> would take forever & I might just as well add up in my head & type in the
>> answer. Any help would be much appreciated,
>> Thanks

Thank you. It didn't work when I dragged the cells, but it did when I copied
& pasted. Thanks for that

"Li'l Roberto" wrote:

> amnt sub paid balance
> > A B C D
> > 1 5 =A1 X =B1-C1
> > 2
> > 3
> >
> > Drag down on each cell to replicate it's formula into the cell
> > below
>
> rgds
> Robert
>
>
> > "chris" <chris@discussions.microsoft.com> wrote in message
> > news:C1B0C37C-B784-4549-A587-8D2CCB432496@microsoft.com...
> >> Hi, I wonder if anyone can help me. I am trying to create a spreadsheet
> >> in
> >> microsoft works. I need the formula for a column to add up balances. i.e.
> >> amount sub paid
> >> balance
> >> collected total out
> >> 5.00 5.00
> >> 5.00
> >> 6.40 ? 3.00
> >> ?
> >>
> >> How would I formulate the subtotal column & the balance column to add up
> >> running totals, or do I have to formulate each cell seperatley, cos that
> >> would take forever & I might just as well add up in my head & type in the
> >> answer. Any help would be much appreciated,
> >> Thanks
>
>
>

Next time, please ask your question in a group with EXCEL in the
title. Notice this group lacks that word.

On Mon, 7 Nov 2005 09:51:05 -0800, "chris"
<chris@discussions.microsoft.com> wrote:

>Thank you. It didn't work when I dragged the cells, but it did when I copied
>& pasted. Thanks for that
>
>"Li'l Roberto" wrote:
>
>> amnt sub paid balance
>> > A B C D
>> > 1 5 =A1 X =B1-C1
>> > 2
>> > 3
>> >
>> > Drag down on each cell to replicate it's formula into the cell
>> > below
>>
>> rgds
>> Robert
>>
>>
>> > "chris" <chris@discussions.microsoft.com> wrote in message
>> > news:C1B0C37C-B784-4549-A587-8D2CCB432496@microsoft.com...
>> >> Hi, I wonder if anyone can help me. I am trying to create a spreadsheet
>> >> in
>> >> microsoft works. I need the formula for a column to add up balances. i.e.
>> >> amount sub paid
>> >> balance
>> >> collected total out
>> >> 5.00 5.00
>> >> 5.00
>> >> 6.40 ? 3.00
>> >> ?
>> >>
>> >> How would I formulate the subtotal column & the balance column to add up
>> >> running totals, or do I have to formulate each cell seperatley, cos that
>> >> would take forever & I might just as well add up in my head & type in the
>> >> answer. Any help would be much appreciated,
>> >> Thanks
>>
>>
>>

You have to grab the cell on the bottom R/Hand corner - you will
see the cursor change to a small black cross when you are in the
correct position for dragging.
*Note* Pasting is not the correct way to do it.

rgds
Robert

>>Thank you. It didn't work when I dragged the cells, but it did when I
>>copied
>>& pasted. Thanks for that
>>
>>"Li'l Roberto" wrote:
>>
>>> amnt sub paid balance
>>> > A B C D
>>> > 1 5 =A1 X =B1-C1
>>> > 2
>>> > 3
>>> >
>>> > Drag down on each cell to replicate it's formula into the
>>> > cell
>>> > below
>>>
>>> rgds
>>> Robert
>>>
>>>
>>> > "chris" <chris@discussions.microsoft.com> wrote in message
>>> > news:C1B0C37C-B784-4549-A587-8D2CCB432496@microsoft.com...
>>> >> Hi, I wonder if anyone can help me. I am trying to create a
>>> >> spreadsheet
>>> >> in
>>> >> microsoft works. I need the formula for a column to add up balances.
>>> >> i.e.
>>> >> amount sub paid
>>> >> balance
>>> >> collected total out
>>> >> 5.00 5.00
>>> >> 5.00
>>> >> 6.40 ? 3.00
>>> >> ?
>>> >>
>>> >> How would I formulate the subtotal column & the balance column to add
>>> >> up
>>> >> running totals, or do I have to formulate each cell seperatley, cos
>>> >> that
>>> >> would take forever & I might just as well add up in my head & type in
>>> >> the
>>> >> answer. Any help would be much appreciated,
>>> >> Thanks
>>>
>>>
>>>
>
>