Hi All,
I have a small problem.
I need to sum a range of numbers and subtract a constant.
I have used the method: {=SUM(B4:BUU4-0.5)}, which gives me a #VALUE error. The problem occurs since there is empty cells in this range. I have also tried with a {=SUM.IF(B4:BUU4,">0",B4:BUU4-0,5)}, but with no success.
Please help
Best regards
/T
I have a small problem.
I need to sum a range of numbers and subtract a constant.
I have used the method: {=SUM(B4:BUU4-0.5)}, which gives me a #VALUE error. The problem occurs since there is empty cells in this range. I have also tried with a {=SUM.IF(B4:BUU4,">0",B4:BUU4-0,5)}, but with no success.
Please help

Best regards
/T