software

I am having a huge issue with having to use simple functions with data coming
from several sheets. Is there such a thing as a quot;compound functionquot;? For
instance quot;AVERAGE(C17)quot; C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1). My next
calculation would be STDEV(C17), instead of re-entering all of the other page
references.

Part A: AVERAGE(C17)
Part B: C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1)

Chris --
two approaches to think about. If your cells are the same on each
worksheet, then you can use, quot;=AVERAGE('Sheet1:Sheet3'!A1). If your cells
are discontinuous, then you might create a named range of all the cells.
Then you can use quot;=AVERAGE(NamedRange)quot;.

HTH

quot;Chris T-Mquot; wrote:

gt; I am having a huge issue with having to use simple functions with data coming
gt; from several sheets. Is there such a thing as a quot;compound functionquot;? For
gt; instance quot;AVERAGE(C17)quot; C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1). My next
gt; calculation would be STDEV(C17), instead of re-entering all of the other page
gt; references.
gt;
gt; Part A: AVERAGE(C17)
gt; Part B: C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1)

How do I rate a post? I juust see Helpful: Yes or No

pdberger
Thanks, The only issue that remains is that Excel help does not return a hit
on quot;NamedRangequot;, but the first approach certainly simplifies my function.

quot;pdbergerquot; wrote:

gt; Chris --
gt; two approaches to think about. If your cells are the same on each
gt; worksheet, then you can use, quot;=AVERAGE('Sheet1:Sheet3'!A1). If your cells
gt; are discontinuous, then you might create a named range of all the cells.
gt; Then you can use quot;=AVERAGE(NamedRange)quot;.
gt;
gt; HTH
gt;
gt; quot;Chris T-Mquot; wrote:
gt;
gt; gt; I am having a huge issue with having to use simple functions with data coming
gt; gt; from several sheets. Is there such a thing as a quot;compound functionquot;? For
gt; gt; instance quot;AVERAGE(C17)quot; C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1). My next
gt; gt; calculation would be STDEV(C17), instead of re-entering all of the other page
gt; gt; references.
gt; gt;
gt; gt; Part A: AVERAGE(C17)
gt; gt; Part B: C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1)

Chris --

Named ranges have a very coolness factor, and you should certainly learn how
to use them. Basically -- select the area you're interested in. Then click
Insertgt;Namegt;Define and give it a name. You can't put spaces or punctuation
marks (hence my NamedRange language) in the name. Then, wherever you are in
that workbook, you can type that name in a formula and Excel knows what cells
you're talking about on which pages.

quot;Chris T-Mquot; wrote:

gt; How do I rate a post? I juust see Helpful: Yes or No
gt;
gt; pdberger
gt; Thanks, The only issue that remains is that Excel help does not return a hit
gt; on quot;NamedRangequot;, but the first approach certainly simplifies my function.
gt;
gt; quot;pdbergerquot; wrote:
gt;
gt; gt; Chris --
gt; gt; two approaches to think about. If your cells are the same on each
gt; gt; worksheet, then you can use, quot;=AVERAGE('Sheet1:Sheet3'!A1). If your cells
gt; gt; are discontinuous, then you might create a named range of all the cells.
gt; gt; Then you can use quot;=AVERAGE(NamedRange)quot;.
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;Chris T-Mquot; wrote:
gt; gt;
gt; gt; gt; I am having a huge issue with having to use simple functions with data coming
gt; gt; gt; from several sheets. Is there such a thing as a quot;compound functionquot;? For
gt; gt; gt; instance quot;AVERAGE(C17)quot; C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1). My next
gt; gt; gt; calculation would be STDEV(C17), instead of re-entering all of the other page
gt; gt; gt; references.
gt; gt; gt;
gt; gt; gt; Part A: AVERAGE(C17)
gt; gt; gt; Part B: C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1)

Thanks pd,
Between the 2 tips, my spreadsheets' running great.

quot;pdbergerquot; wrote:

gt; Chris --
gt;
gt; Named ranges have a very coolness factor, and you should certainly learn how
gt; to use them. Basically -- select the area you're interested in. Then click
gt; Insertgt;Namegt;Define and give it a name. You can't put spaces or punctuation
gt; marks (hence my NamedRange language) in the name. Then, wherever you are in
gt; that workbook, you can type that name in a formula and Excel knows what cells
gt; you're talking about on which pages.
gt;
gt; quot;Chris T-Mquot; wrote:
gt;
gt; gt; How do I rate a post? I juust see Helpful: Yes or No
gt; gt;
gt; gt; pdberger
gt; gt; Thanks, The only issue that remains is that Excel help does not return a hit
gt; gt; on quot;NamedRangequot;, but the first approach certainly simplifies my function.
gt; gt;
gt; gt; quot;pdbergerquot; wrote:
gt; gt;
gt; gt; gt; Chris --
gt; gt; gt; two approaches to think about. If your cells are the same on each
gt; gt; gt; worksheet, then you can use, quot;=AVERAGE('Sheet1:Sheet3'!A1). If your cells
gt; gt; gt; are discontinuous, then you might create a named range of all the cells.
gt; gt; gt; Then you can use quot;=AVERAGE(NamedRange)quot;.
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; quot;Chris T-Mquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am having a huge issue with having to use simple functions with data coming
gt; gt; gt; gt; from several sheets. Is there such a thing as a quot;compound functionquot;? For
gt; gt; gt; gt; instance quot;AVERAGE(C17)quot; C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1). My next
gt; gt; gt; gt; calculation would be STDEV(C17), instead of re-entering all of the other page
gt; gt; gt; gt; references.
gt; gt; gt; gt;
gt; gt; gt; gt; Part A: AVERAGE(C17)
gt; gt; gt; gt; Part B: C17=('Sheet1'!A1,'Sheet2'!A1,'Sheet3'!A1)