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) |
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 |