I'm using Data Validation to allow only one of two cells to be used in a multiplication scenario. Another forum member suggested using 
=COUNTA(A1:B1)=1
as the Data Validation custom allowable (formula) but unfortunately it also counts "0", "0.0" and "-" (absolute zero). How can I adapt this approach to ignore "0" and "-"?
Thanks. David