Forum Discussion
Solved
How to write a formula to sum cells with certain criteria?
Dear all, I would like to sum cells that are not blank to fulfill the following criteria: 1. when the sum range is blank, then blank 2. when the sum range equals to zero, then 0 Your help w...
If you want to sum the range say A2:A10, you may try something like this...
=IF(COUNTA(A2:A10)=0,"",SUM(A2:A10))
If you want to sum the range say A2:A10, you may try something like this...
=IF(COUNTA(A2:A10)=0,"",SUM(A2:A10))
Thank you so much.
Subodh_Tiwari_sktneerYou're welcome leochan2003!
