Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Extracting data with "0"s instead of "" (blanks)


I've a very simple yet not solved question; are there a way to extract data with blank cells with 0's instead of "" (blanks)? I mean, for example, when I use countif(colx;"<>"&0) function in excel, which basically returns the number of cells in a column that is not equal to 0, returns +100.00. It simply shows that blank cells are not 0's, they are filled with blanks instead.

Thanks a lot in advance!
asked Apr 20 by CaEr (430 points)

Your solution to the original question

Please only use this to answer the original question. Otherwise please use comments.
Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:

To avoid this verification in future, please log in or register.