Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

total formulas

Posted 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 formulas

Posted 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
=SUM(B1:B20)


b1..b20 vs b1:b20 lotus vs excel nomenclature

Posted 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
keystroke.


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.