EXCEL formula IF

Report
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hello,
Can someone help me? I want a formula to show OK if the cell beside it have some value.
Example:

A1: to be filled with D.O number (will only available once the D.O is received)
B1: OK (if the D.O number is entered)

I have list of thousand item in 1 sheet, need to monitor the completion of each item. if they have the D.O number, then the process of the item is completed.

Let say the list have 100 no of item, only 10 have the D.O number, then the progress will be 10 over 100 (10%).

Anyone have any idea how to easily monitor the completion of item?
Thank you.


System Configuration: Windows / Chrome 96.0.4664.93

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Mayra,

So you basically want to count cells that contain data.
=COUNTIF(B2:B101,"*")

When the D.O numbers are located in range B2 to B101 and only 10 cells contain data, then the result of the formula above will be 10.

Is this what you are looking for?

Best regards,
Trowa