Countif/Sumif function question
 

I'm trying to generate a percentage formula on a worksheet from
calculations on another. I linked the calculation and I'm trying to use
countif(e5:e15,"<2")/countif(e5:e15,"<0") Is this not working because I
need to reference the sheet instead of my rows
countif(sheet1:sheet10!A1,"<2")/countif(sheet1:sheet10!A1"<0") Will
this work or is there an easier solution. Thanks.


--
psyd
------------------------------------------------------------------------
psyd's Profile: http://www.excelforum.com/member.php...o&userid=16106
View this thread: http://www.excelforum.com/showthread...hreadid=275538