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
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
Posted by Mark W. on August 15, 2001 6:38 AM
Make that...
=SUM(B1:B20)
Posted by Eric on August 15, 2001 7:51 AM
b1..b20 vs b1:b20 lotus vs excel nomenclature
no worries, excel works with either one
Posted by Mark W. on August 15, 2001 8:02 AM
Perhaps, but...
...I'm an Excel bigot : ) and ":" is one less
keystroke.
