Re: array question

In article <jemcgimpsey-A207E6.00385929072005@xxxxxxxxxxxxxxxxxxxx>,
JE McGimpsey <jemcgimpsey@xxxxxxxx> wrote:

> In article <info-376006.10564128072005@xxxxxxxxxxxxxxxxxxxx>,
> Harvey Waxman <info@xxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > {=AVERAGE(IF(($J$12:$J$10786>R1)*($J$12:$J$10786<=R2),$S$12:$S$10786))}
> >
> > In the above, column J is a column of values
> > R1 - R5 is a list of values in numerical order 150, 300, 800, 5000 etc.
> > Column S contains percentages
> >
> > The formula displays the average percentage of all values in column J that
> > are
> > greater than R1 AND less than or equal R2.
> >
> > Can someone explain why the formula works by multiplying the ranges?
>
>
> Lets take just four values:
>
> J R S
> 1 150
> 2 300
> ...
> 12 180 10%
> 13 425 20%
> 14 146 30%
> 15 294 40%
>
Great explanation. Many thanks, as usual

--
Harvey Products makers of Dinghy Dogs?
The Boater's Best Friend
http://www.dinghydogs.com
Remove thefrown to email me
.