| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto sum?
filling in data in each row left to right. at end of row is the total cloumn.
trying to figure out right formula to auto calculate and also at the bottom of the total column. does anyone know how this is done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto sum?
this will sum columns A to J in row 1
=SUM(A1:J1) this will sum rows 1 to 10 in column A =SUM(A1:A10) You'll find a good explanation of the SUM function in the Excel help. Search for "SUM worksheet function" "teddkilroy" wrote: filling in data in each row left to right. at end of row is the total cloumn. trying to figure out right formula to auto calculate and also at the bottom of the total column. does anyone know how this is done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto sum?
If I understand correctly, this should work.
=SUM(A1:D1) "teddkilroy" wrote: filling in data in each row left to right. at end of row is the total cloumn. trying to figure out right formula to auto calculate and also at the bottom of the total column. does anyone know how this is done? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto sum?
selecting an empty cell at the bottom of the row or column and pressing
auto-sum button is a nice shortcut "teddkilroy" wrote: filling in data in each row left to right. at end of row is the total cloumn. trying to figure out right formula to auto calculate and also at the bottom of the total column. does anyone know how this is done? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto sum?
yes to all who reply this is what i have:
Rent Non Food Clothing Utilities Bus Total $200.00 $40.00 $35.00 0 $25.00 $300.00 row row Total Total Total Total Total Total with 300.00 the total of that row and to the far right (same row) is fname,lname (same cell). i wanted to auto sum at the end of row and auto sum at the end of each column especially the total colum. Second, if the first cell is fname,lname if I a-z that column how will the other columns be affected? Thanks to all you have replied. "Mike" wrote: selecting an empty cell at the bottom of the row or column and pressing auto-sum button is a nice shortcut "teddkilroy" wrote: filling in data in each row left to right. at end of row is the total cloumn. trying to figure out right formula to auto calculate and also at the bottom of the total column. does anyone know how this is done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
| How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
| is there a way to auto copy cells similar to auto sum? | Excel Worksheet Functions | |||
| Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Linear Mode
