Forum Discussion
Luis BERNAL
Feb 21, 2019Copper Contributor
Sumif not blank
Hello! I want to use a formula to ignore blank cells when i sum blank spaces but if I use "Sum(J6:J9)" it will give me a "0" even if there's no values in the cell, and what i'm trying to do is basic...
- Feb 22, 2019
Another variant
=IF(ISNA(IFERROR(LARGE(A1:A5,1),NA())),"",SUM(A1:A5))
SergeiBaklan
Feb 21, 2019Diamond Contributor
=if(sum(J6:J9)=0,"",Sum(J6:J9))