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

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

This archive is from the original message board at
All contents © 1998-2004
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.