=IF(AND(COUNT(B2:B16)=COUNTA(B2:B16),COUNTBLANK(B2:B16)=0),SUM(B2:B16),"Fill with numbers") Thank you for your suggestion! The formula you provided is indeed a great improvement. By using AND along with COUNT and COUNTA, it ensures that all cells contain numeric values and that none are blank. This adds an extra layer of validation, making it even more robust. I appreciate your input and will consider including it in future tutorials. Keep the ideas coming!
a much better improvement: =IF(AND(COUNT(A1:A10)=COUNTA(A1:A10);COUNTBLANK(A1:A10)=0);SUM(A1:A10);"Fill with numbers")
=IF(AND(COUNT(B2:B16)=COUNTA(B2:B16),COUNTBLANK(B2:B16)=0),SUM(B2:B16),"Fill with numbers")
Thank you for your suggestion! The formula you provided is indeed a great improvement. By using AND along with COUNT and COUNTA, it ensures that all cells contain numeric values and that none are blank. This adds an extra layer of validation, making it even more robust. I appreciate your input and will consider including it in future tutorials. Keep the ideas coming!
Thanks a lot sir.
You're welcome!