Search results

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...

@Luke M You're awesome dude. Thanks! It worked except I modified the "logical_false" to "" to keep the cell blank if nothing is entered. Appreciate everyone's help!

@shailyog Thanks, but I could not get the array function to not work. It did not show a cell error anymore, but only B1 out of the range of B1:B10 worked correctly. I need A1 to return "X" if "XXX" is entered into any cell B1 through B10.

Thanks Hui. But I don't necessarily need to copy the formula to a range of cells, but I need to include a range of cells into the formula so that if any cell B1:B10 are input with "XXX", then excel will automatically (OR automagically) input "X" into A1. So...=IF(B1:B10="XXX","X","") for...

Perfect! Thanks. Now, what if I wanted to do this in a range of cells?

I need to have excel input an "X" in a cell, after a another cell has had data input in it. For example, I need A1 to automatically display "X" after "XXX" has been manually input into B1. However, I am not THAT fimilar with VBA or Macros so if there is a formula to input that would be...