Excel - excel formula

Hi Friends

Im facing a problem with the small issue will u please clarify me the formula

A1   OK
A2   OK
A3   OK
A4   NO
A5   OK
A6   OK
A7   OK
A8   NO
A9     ?

here the problem with the A9, I need the value of the A9 should be Perfect
when A1 to A8 are OK
if we have any one of this A1 to A8 as NO the value should be return as
Pending

If u can help me i will be thankful for U friend

  Max replied to sudheer

One way
In A9: =IF(COUNTIF(A1:A8,"OK")=8,"Perfect","Pending")
Yes?, hit the YES below
--
Max
Singapore
---

  Jacob Skaria replied to sudheer

Try
=IF(COUNTIF(A1:A8,"OK")=8,"Perfect","Pending")

--
Jacob

I do have some students more than once? Version 2003 Excel Setup Discussions Excel (1) COUNTIF (1) Database (1) HiOne (1) WayIn (1) Fromlumns (1) Rosters (1) Lumns (1) from lumns) if you have no blank entries duplicates very easily. Hi One way In cell C1 enter the following formula = IF(A1 = "", "", COUNTIF($A$1:A1, A1)) and copy down as far as required You will see a

Countif(Not blank) Excel Trying to count cells in the indicated cell that are not blank. This is what I tried, but it still counts blank cells. = (COUNTIF(AB4, "<> """)+COUNTIF(AG4, "<> """)+COUNTIF(AL4, "<> """)+COUNTIF(AQ4, "<> """)) Thanks Excel Worksheet Discussions SUMPRODUCT (1) COUNTIF (1) COLUMN (1) MOD (1) Just use "<> " rather than "<> """ Regards, Fred. Try this: = SUMPRODUCT(- -(MOD COLUMN(AB4:AQ4), 5) = 3), - -(AB4:AQ4<> "")) To work, your formula would have to be = COUNTIF(AB4, "<> "&"")+COUNTIF(AG4, "<> "&"")+COUNTIF(AL4, "<> "&"")+COUNTIF(AQ4, "<> "&"") However, as Fred said, you can use the simpler = COUNTIF

How to apply countif? Excel Does anyone have any suggestions on how to apply countif? = Countif(Range, Criteria) There is a table C1:Z100, and there is a list of number A100 There is a given number 3 in cell A200, I would like to apply countif function under the column B in order to find out how many numbers under the Thanks in advance for any suggestions Eric Excel Miscellaneous Discussions Microsoft Excel (1) FREQUENCY (1) COUNTIF (1) Eric (1) Rng (1) One way: C1:Z100 = rng Entered in B1 and copied down as needed: = COUNTIF(rng, "> = "&A1-A200)-COUNTIF(rng, "> "&A1+A200) - - Biff Microsoft Excel MVP If you do not mind hard coding the rng, A1+{3, -4}) - - Biff Microsoft Excel MVP Better make that reference to A200 absolute: = COUNTIF(rng, "> = "&A1-A$200)-COUNTIF(rng, "> "&A1+A$200) - - Biff Microsoft Excel MVP keywords: How

CountIf Dynamic Excel How can I use the CountIf dynamically? COUNTIF($E$6:$E$2725, "> = J47")-COUNTIF($E$6:$E$2725, "> = K47") Where J47 and K47 are numeric cell references. If this column of values in a user defined range. Thank you very much. Excel Miscellaneous Discussions COUNTIF (1) If I understand your question correctly: = COUNTIF($E$6:$E$2725, "> = " & J47)-COUNTIF($E$6:$E$2725, "> = " & K47) try = COUNTIF($E$6:$E$2725, "> = "& J47)-COUNTIF($E$6:$E$2725, "> = "& K47) Mike One way: = COUNTIF