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

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

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

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