View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default What is the Excel formula for adding 1 column with several rows?

=SUM(J3:J71)


Gord Dibben MS Excel MVP

On Mon, 21 Aug 2006 18:50:51 -0700, ljsbjs
wrote:

I need to the sum of one column - several rows. Example: Column J rows 3 thru
71 without entering each column and row number.