Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on "Value" function | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Grading Function Question... | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |