EXCEL formula IF

Closed
Mayra - Dec 15, 2021 at 03:36 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 16, 2021 at 12:21 PM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 16, 2021 at 12:21 PM
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
0