Calculating Between Values

F

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
 
B

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)
 
Top