Thread: How to sum a column from not the first cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How to sum a column from not the first cell
either:
=SUM(D3:D65536)
or =SUM(D:D)-D1-D2
--
Gary's Student
gsnu200702


"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.
--
D.A. Cluett
Ad majorem Dei gloriam
Reply With QuoteReply With Quote