hello!

found this thread and I want to do the same but using the countif function...

http://www.excelforum.com/excel-prog...-a-number.html

is there a way to adapt the non-vba if statement and place into the below code?

=COUNTIF(my_data!X:X, [what to put here?] )
Thank you so much!