| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas withing Formulas
How do I create a formula that will only include numbers that are above
another numbers that is created i.e. If Volume is 4,000, then I need to multiple this number by 10% and then find the average of a column of numbers as long as the numbers are above, in this example, 400? Hopefully that makes sense... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formulas withing Formulas
On Tue, 16 Aug 2005 13:18:08 -0700, Darren
wrote: How do I create a formula that will only include numbers that are above another numbers that is created i.e. If Volume is 4,000, then I need to multiple this number by 10% and then find the average of a column of numbers as long as the numbers are above, in this example, 400? Hopefully that makes sense... perhaps something like: If Volume is in, let us say, B1; and your numbers are in column A: =SUMIF(A:A,"="&1.1*B1)/COUNTIF(A:A,"="&1.1*B1) --ron |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formulas withing Formulas
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? "Ron Rosenfeld" wrote: On Tue, 16 Aug 2005 13:18:08 -0700, Darren wrote: How do I create a formula that will only include numbers that are above another numbers that is created i.e. If Volume is 4,000, then I need to multiple this number by 10% and then find the average of a column of numbers as long as the numbers are above, in this example, 400? Hopefully that makes sense... perhaps something like: If Volume is in, let us say, B1; and your numbers are in column A: =SUMIF(A:A,"="&1.1*B1)/COUNTIF(A:A,"="&1.1*B1) --ron |
|
#4
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 | |||
Linear Mode
