Oct 06 2020 09:08 PM
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 would be very much appreciated.
Oct 06 2020 10:02 PM
SolutionIf you want to sum the range say A2:A10, you may try something like this...
=IF(COUNTA(A2:A10)=0,"",SUM(A2:A10))
Oct 07 2020 12:59 AM - edited Oct 07 2020 01:02 AM
@leochan2003 ,,,
You may use either of these:
=IF(NOT(COUNTA(A1:A10)),"",SUM(A1:A10))
{=IF(ISBLANK(A1:A10),"",IF(A1:A10=0, 0,SUM(A1:A10)))}
Note: Second formula is as array (CSE) formula, so finish it with Ctrl+Shift+Enter.
How it works:
Otherwise gets the SUM.
Oct 07 2020 04:50 PM
Thank you so much.
@Subodh_Tiwari_sktneer
Oct 08 2020 12:40 AM
You're welcome @leochan2003!
Oct 06 2020 10:02 PM
SolutionIf you want to sum the range say A2:A10, you may try something like this...
=IF(COUNTA(A2:A10)=0,"",SUM(A2:A10))