I want to add cells, eg E1-E100

[Don Guillett]

Have a look in the help index for SUM

 

[Gord Dibben]

=SUM(E1:E100)


Gord Dibben MS Excel MVP