Countif/Sumif function question

P

psyd

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
Excel Countif Function - Calculating Between Two Sets of Values 3
SUM of a 3D calculation 6
Combination of IF, AND, and COUNTIF; need help 6
COUNTIF Function Formula Question 7
Simple COUNTIF problem 5
function question (sumif countif conditional) 0
Using countif with multiple criteria 0

Top