MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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.