| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find SUM when you already have the range?
Try this:
A1 = D5:D10 =SUM(INDIRECT(A1)) -- Biff Microsoft Excel MVP "bau" wrote in message ... 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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find SUM when you already have the range?
Give this a try...
=SUM(INDIRECT(A2)) -- HTH... Jim Thomlinson "bau" wrote: 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, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find SUM when you already have the range?
It works beautifully.
Thanks!!! "T. Valko" wrote: Try this: A1 = D5:D10 =SUM(INDIRECT(A1)) -- Biff Microsoft Excel MVP "bau" wrote in message ... 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, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find SUM when you already have the range?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "bau" wrote in message ... It works beautifully. Thanks!!! "T. Valko" wrote: Try this: A1 = D5:D10 =SUM(INDIRECT(A1)) -- Biff Microsoft Excel MVP "bau" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I find the last value of a range.... | Excel Worksheet Functions | |||
| Find value in range | Excel Discussion (Misc queries) | |||
| Find a range of values in a range of cells | Excel Worksheet Functions | |||
| Find first value in range | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
Linear Mode
