How to find SUM when you already have the range?

Giganews Newsgroups
Subject: How to find SUM when you already have the range?
Posted by:  bau
Date: Mon, 13 Aug 2007

Hi all,
  I have a situation where column A has different range value, I would like
to find the sum for the indicated range in the colum A. What should I write
in colum B (say in cell B2) instead of typing of "=SUM(" then drag cell D5
through D10?

Column A    Column B
Range        Total
D5:D10      =SUM(D5:D10)
D7:D9

Many thanks,

Replies