Posted to microsoft.public.excel.misc

external usenet poster

Posts: 22

How to find SUM when you already have the range?

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,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I find the last value of a range....	Kath	Excel Worksheet Functions	9	June 12th 08 03:07 PM
Find value in range	EstherJ	Excel Discussion (Misc queries)	3	January 24th 07 02:11 PM
Find a range of values in a range of cells	Jack Taylor	Excel Worksheet Functions	20	November 25th 06 01:26 PM
Find first value in range	[email protected]	Excel Discussion (Misc queries)	4	June 14th 06 06:29 AM
Find dates in a range; then sum values in that range by a criteria	Anders	Excel Discussion (Misc queries)	4	October 21st 05 03:41 PM

All times are GMT +1. The time now is 07:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us