trying to make a formula for percent if greater than a value

Thanks guys for all your help. For future seakers of the solution, here's
what I've done...

=(COUNTIF(F12,"0")+COUNTIF(I12,"0")+COUNTIF(L12, "0")+COUNTIF(O12,"0")+COUNTIF(R12,"0")+COUNTIF( U12,"0"))/COUNT(F12,I12,L12,O12,R12,U12)


=SUM(IF(F120,F12,FALSE),IF(I120,I12,FALSE),IF(L1 20,L12,FALSE),IF(O120,O12,FALSE),IF(R120,R12,FA LSE),IF(U120,U12,FALSE))/(COUNTIF(F12,"0")+COUNTIF(I12,"0")+COUNTIF(L12," 0")+COUNTIF(O12,"0")+COUNTIF(R12,"0")+COUNTIF(U 12,"0"))


=SUM(IF(F120,G12,FALSE),IF(I120,J12,FALSE),IF(L1 20,M12,FALSE),IF(O120,P12,FALSE),IF(R120,S12,FA LSE),IF(U120,V12,FALSE))/(COUNTIF(F12,"0")+COUNTIF(I12,"0")+COUNTIF(L12," 0")+COUNTIF(O12,"0")+COUNTIF(R12,"0")+COUNTIF(U 12,"0"))

This gives me my percent survival, my average rank of those that survived,
and the average of the number of whatevers that correspond to surviving
units. Hope it helps.

Thanks again for all the advice!



"cervenyc" wrote:

I got it to work, but the formula averages a zero when the statement is
false. How do I make a false statement render a blank cell, or to drop the
value? If the value is 0, then I want it excluded, I only want to average
values greater than 0. Thanks.



"SteveG" wrote:


Enter the formula as you normally would.


=AVERAGE(IF(A1:A80,A1:A8,FALSE))

When you are done typing in the formula, rather than hitting the Enter
key, hit the Ctrl, Shift & Enter keys simultaneously. That will create
the {} around the formula automatically. Don't type them in yourself.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=499913