Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is the Excel formula for adding 1 column with several rows?
I need to the sum of one column - several rows. Example: Column J rows 3 thru
71 without entering each column and row number. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is the Excel formula for adding 1 column with several rows?
=SUM(J3:J71)
Gord Dibben MS Excel MVP On Mon, 21 Aug 2006 18:50:51 -0700, ljsbjs wrote: I need to the sum of one column - several rows. Example: Column J rows 3 thru 71 without entering each column and row number. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is the Excel formula for adding 1 column with several rows?
And a variation that allows you to insert rows immediately
before the formula. J72: =SUM(J$3:OFFSET(J72,-1,0)) see http://www.mvps.org/dmcritchie/excel/offset.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Gord Dibben" <gorddibbATshawDOTca wrote... =SUM(J3:J71) On Mon, 21 Aug 2006 18:50:51 -0700, ljsbjs wrote: I need to the sum of one column - several rows. Example: Column J rows 3 thru 71 without entering each column and row number. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is the Excel formula for adding 1 column with several rows?
David,
Thank you for telling us about using Offset() in a situation like this or something similar. It is dynamic. This is the kind of "tricks" or smart tips I look forward to learning from MVP's. Your website is full of excellent info. Thank you for sharing your expertise and time. Cheers, Epinn "David McRitchie" wrote in message ... And a variation that allows you to insert rows immediately before the formula. J72: =SUM(J$3:OFFSET(J72,-1,0)) see http://www.mvps.org/dmcritchie/excel/offset.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Gord Dibben" <gorddibbATshawDOTca wrote... =SUM(J3:J71) On Mon, 21 Aug 2006 18:50:51 -0700, ljsbjs wrote: I need to the sum of one column - several rows. Example: Column J rows 3 thru 71 without entering each column and row number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Excel Idiot Needs Formula Help!! | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |