Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I am a novice in excel programming, so bear with me. I have figured out how to do most formulas (may be crude, but it works) where I select the cell (Range("B2").Select) and then I paste a function, in my Stats sheet, that is a sum over a 3-d reference (the other sheets in my workbook). My last two formulas of the Stats sheet are a sum and an average over the same 3-d range. I was able to get the first, using the above mentioned method, but how do I get the 3-d average over cells B105, but put this function in cell B108 of my Stats sheet? Recall that the cell B105 of the Stats sheet already has a function for the sum. Thanks Carrie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula based on variable range | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
Macro to input formula in range based on another range | Excel Programming | |||
How can I format text pased directly from clipboard to appear in correct cells | Excel Programming |