| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas withing Formulas
On Tue, 16 Aug 2005 13:58:03 -0700, Darren
wrote: The formula works great when I made an example, but how do I change the formula it if the volume is in G2 and the columns are G5:G22? =SUMIF(G5:G22,"="&1.1*G2)/COUNTIF(G5:G22"="&1.1*G2) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Hybrid Mode
