Formula

G

Gord Dibben

turner

=SUM(A1:A10) entered in B1

=SUM(A:A) entered in B1

Select the range of numbers then click on the AutoSum button on the Standard
Toolbar. Looks like a sideways M

Gord Dibben Excel MVP
 
Top