Calculating Between Values

[Flipside]

Hope you can help me!

I have a column on one spreadsheet called "Platts Ports"

Now, I want to analize column E. I want to be able to pick out all the values between 0 & 0 (>0 &<2). I then want to say the following:

Where value = between 0-2 (COUNT) then add up column F where all these fields apply. Then divide COUNT(E) by the total of F( the sum we just calculated)

To top this off, I need to do this from another sheet (within the same Spreadsheet)

Hope you understand.



Email me at [email protected] if you need me to priovide more info!


Thanks in advance

[Bob Phillips]

I think I do

SUMPRODUCT(--(Sheet1!E1:E100>0),--(Sheet1!E1:E100<2))/
=SUMPRODUCT(--(Sheet1!E1:E100>0),--(Sheet1!E1:E100<2),Sheet1!F1:F100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Flipside" <[email protected]> wrote in
message news:[email protected]...
>
> Hope you can help me!
>
> I have a column on one spreadsheet called "Platts Ports"
>
> Now, I want to analize column E. I want to be able to pick out all the
> values between 0 & 0 (>0 &<2). I then want to say the following:
>
> Where value = between 0-2 (COUNT) then add up column F where all these
> fields apply. Then divide COUNT(E) by the total of F( the sum we just
> calculated)
>
> To top this off, I need to do this from another sheet (within the same
> Spreadsheet)
>
> Hope you understand.
>
>
>
> Email me at [email protected] if you need me to priovide more info!
>
>
> Thanks in advance
>
>
> --
> Flipside
> ------------------------------------------------------------------------
> Flipside's Profile:
http://www.excelforum.com/member.php...o&userid=17111
> View this thread: http://www.excelforum.com/showthread...hreadid=499790
>

[Flipside]

Thanks alot man.

Great Help!!!