| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make a compound function?
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 "compound function"? For instance "AVERAGE(C17)" 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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a compound function?
Chris --
two approaches to think about. If your cells are the same on each worksheet, then you can use, "=AVERAGE('Sheet1:Sheet3'!A1). If your cells are discontinuous, then you might create a named range of all the cells. Then you can use "=AVERAGE(NamedRange)". HTH "Chris T-M" wrote: 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 "compound function"? For instance "AVERAGE(C17)" 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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a compound function?
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 "NamedRange", but the first approach certainly simplifies my function. "pdberger" wrote: Chris -- two approaches to think about. If your cells are the same on each worksheet, then you can use, "=AVERAGE('Sheet1:Sheet3'!A1). If your cells are discontinuous, then you might create a named range of all the cells. Then you can use "=AVERAGE(NamedRange)". HTH "Chris T-M" wrote: 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 "compound function"? For instance "AVERAGE(C17)" 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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a compound function?
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 InsertNameDefine 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. "Chris T-M" wrote: 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 "NamedRange", but the first approach certainly simplifies my function. "pdberger" wrote: Chris -- two approaches to think about. If your cells are the same on each worksheet, then you can use, "=AVERAGE('Sheet1:Sheet3'!A1). If your cells are discontinuous, then you might create a named range of all the cells. Then you can use "=AVERAGE(NamedRange)". HTH "Chris T-M" wrote: 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 "compound function"? For instance "AVERAGE(C17)" 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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a compound function?
Thanks pd,
Between the 2 tips, my spreadsheets' running great. "pdberger" wrote: 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 InsertNameDefine 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. "Chris T-M" wrote: 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 "NamedRange", but the first approach certainly simplifies my function. "pdberger" wrote: Chris -- two approaches to think about. If your cells are the same on each worksheet, then you can use, "=AVERAGE('Sheet1:Sheet3'!A1). If your cells are discontinuous, then you might create a named range of all the cells. Then you can use "=AVERAGE(NamedRange)". HTH "Chris T-M" wrote: 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 "compound function"? For instance "AVERAGE(C17)" 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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ? | Excel Discussion (Misc queries) | |||
| HOW DO YOU MAKE FORECAST FUNCTION WORK IN EXCEL? | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| how do I make a function to count days? | Excel Worksheet Functions | |||
Linear Mode
