I need a conditional count formula (I assume a COUNT formula)that will count the number of rows in a column only if a cell in the same row contains "X".
For example, C1 thru C10 contains activities, cells F1 thru F10 contain an "X" that tells the user the activity has been completed. I need a formula that will automatically count the activities that have been completed, while ignoring the activities that have not been completed.
But the row can should only be counted if an "X" has been placed in the "Complete" cell.
For example, C1 thru C10 contains activities, cells F1 thru F10 contain an "X" that tells the user the activity has been completed. I need a formula that will automatically count the activities that have been completed, while ignoring the activities that have not been completed.
But the row can should only be counted if an "X" has been placed in the "Complete" cell.
