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 (E-Mail Removed) 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

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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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 (E-Mail Removed) 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!!!


--
Flipside
------------------------------------------------------------------------
Flipside's Profile: http://www.excelforum.com/member.php...o&userid=17111
View this thread: http://www.excelforum.com/showthread...hreadid=499790