Feb 21 2019 08:52 AM
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 basically this: "if(sum(J6:J9)="","",Sum(J6:J9))" but the formula is still taking a blank space as "0" so it will give me again "0" when i'm trying to ignore those blank spaces.
Any ideas?
Feb 21 2019 09:18 AM
Feb 21 2019 10:24 AM
Hi Twifoo,
Thanks for your fast response, the thing is that, if i use that formula, there's sometimes when the number might be "0", and that's ok for me, but if the cell is blank, the result of that "sum" formula is still giving me "0".
Imagine inside the bottom cell is the "sum" formula.
This is ok
1 |
1 |
0 |
0 |
2 |
This is also ok.
This is not ok.
0 |
Feb 21 2019 07:52 PM
Feb 22 2019 01:10 PM
SolutionAnother variant
=IF(ISNA(IFERROR(LARGE(A1:A5,1),NA())),"",SUM(A1:A5))
Feb 22 2019 01:10 PM
SolutionAnother variant
=IF(ISNA(IFERROR(LARGE(A1:A5,1),NA())),"",SUM(A1:A5))