ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   easy calc excell (https://www.excelbanter.com/excel-discussion-misc-queries/17330-easy-calc-excell.html)

titont

easy calc excell
 
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

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" wrote in message
...
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




titont

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" wrote in message
...
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

lol :)

glad it worked

Cheers
JulieD

"titont" wrote in message
...
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" wrote in message
...
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








All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com