![]() |
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 |
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 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 |
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