What is the Excel formula for adding 1 column with several rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thank you for telling us about using Offset() in a situation like this or
something similar. It is dynamic. This is the kind of "tricks" or smart
tips I look forward to learning from MVP's. Your website is full of
excellent info. Thank you for sharing your expertise and time.

Cheers,

Epinn
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Delete a formula but leave the data. 2
Subtracting figures in a column 3
Excel Concatenate with line breaks but ignore blank cells 3
Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
FORMULA CHANGES 2
How do number columns first, then the rows in an excel footer? 1

Back
Top