Calculating Between Values

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 RBotley@Gmail.com if you need me to priovide more info!


Thanks in advance

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" <Flipside.21ffra_1136910001.1962@excelforum-nospam.com> wrote in
message news:Flipside.21ffra_1136910001.1962@excelforum-nospam.com...
>
> 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 RBotley@Gmail.com 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
>

Thanks alot man.

Great Help!!!