How to sum a column from not the first cell

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

Guest

I want to sum all figures in a column -- e.g. sum(d:d) -- but want the top
item to not the the top cell -- e.g. sum(d3:d). Please advise if anyone can
figure out how to do this? I'm stumped.
 
D.A. Cluett wrote:

:: I want to sum all figures in a column -- e.g. sum(d:d) -- but want
:: the top item to not the the top cell -- e.g. sum(d3:d). Please
:: advise if anyone can figure out how to do this? I'm stumped.

Well there are 65536 cells in total in the column so you could try
=SUM(D3:D65536)
 
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

Sum Values from different column 1
Sum every Nth Row (almost working) 1
In column B:B and D:D I've a Formula 6
Sum of a column from nth row to end 17
Get percentage of whole 2
Sum with a slash "/" 6
SUM - IF - AND 7
sum of multiple rows 2

Back
Top