I use to use easy calc (works spreadsheet) to add, etc to auto fill out the
totals in another cell, I cant figure out how to do it in Excel>
I use to use easy calc (works spreadsheet) to add, etc to auto fill out the
totals in another cell, I cant figure out how to do it in Excel>
hi
if you're asking how to add up some numbers, e.g. the numbers in the range
B3:B7
in B8 use
=SUM(B3:B7)
to autofil this formula across to C8, D8 etc
move your mouse over the bottom right hand corner of B8, when you see an +
hold your left mouse button down and drag right
if you're copying down a column i.e. from H8 to H9 to H10 etc
when you see the + double click on it - this will work if either column G or
I has information in it.
Cheers
JulieD
"titont" <[email protected]> wrote in message
news:[email protected]...
>I use to use easy calc (works spreadsheet) to add, etc to auto fill out the
> totals in another cell, I cant figure out how to do it in Excel>
JulieD You are the MAN or ummm.....WOMEN!??!?!?!?
Thank you very much, i love ya!!
Chad K
"JulieD" wrote:
> hi
>
> if you're asking how to add up some numbers, e.g. the numbers in the range
> B3:B7
> in B8 use
> =SUM(B3:B7)
> to autofil this formula across to C8, D8 etc
> move your mouse over the bottom right hand corner of B8, when you see an +
> hold your left mouse button down and drag right
>
> if you're copying down a column i.e. from H8 to H9 to H10 etc
> when you see the + double click on it - this will work if either column G or
> I has information in it.
>
> Cheers
> JulieD
>
> "titont" <[email protected]> wrote in message
> news:[email protected]...
> >I use to use easy calc (works spreadsheet) to add, etc to auto fill out the
> > totals in another cell, I cant figure out how to do it in Excel>
>
>
>
lol
glad it worked
Cheers
JulieD
"titont" <[email protected]> wrote in message
news:[email protected]...
> JulieD You are the MAN or ummm.....WOMEN!??!?!?!?
>
> Thank you very much, i love ya!!
>
>
> Chad K
>
> "JulieD" wrote:
>
>> hi
>>
>> if you're asking how to add up some numbers, e.g. the numbers in the
>> range
>> B3:B7
>> in B8 use
>> =SUM(B3:B7)
>> to autofil this formula across to C8, D8 etc
>> move your mouse over the bottom right hand corner of B8, when you see an
>> +
>> hold your left mouse button down and drag right
>>
>> if you're copying down a column i.e. from H8 to H9 to H10 etc
>> when you see the + double click on it - this will work if either column G
>> or
>> I has information in it.
>>
>> Cheers
>> JulieD
>>
>> "titont" <[email protected]> wrote in message
>> news:[email protected]...
>> >I use to use easy calc (works spreadsheet) to add, etc to auto fill out
>> >the
>> > totals in another cell, I cant figure out how to do it in Excel>
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks