Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
total formulasPosted by leonie on August 15, 2001 5:44 AM
Can anyone tell me the formula to add a column of figures, i think its something to with = sum but thats where i get stuck
Re: total formulasPosted by Andrew Cheung on August 15, 2001 5:55 AM
Suppose you have the data in Column B (Cells B1 to B20).
In cell B21, just type "=sum(b1..b20)" and you can sum the data from B1 to B20
Make that...Posted by Mark W. on August 15, 2001 6:38 AM
b1..b20 vs b1:b20 lotus vs excel nomenclaturePosted by Eric on August 15, 2001 7:51 AM
no worries, excel works with either one
Perhaps, but...Posted by Mark W. on August 15, 2001 8:02 AM
...I'm an Excel bigot : ) and ":" is one less
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.