Subtract constant in sum function

[KayserDK]

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

 

[mohadin]

Hi If I Understand
tryT

=SUM(B4:BUU4)-0.5

 

[KayserDK]

Hi If I Understand
tryT

=SUM(B4:BUU4)-0.5

Maybe I was not precise enough. I need to subtract the constant from each cell in the range.

 

[Peter_SSs]

Maybe I was not precise enough. I need to subtract the constant from each cell in the range.

Try

=SUM(B4:BUU4)-0.5*COUNT(B4:BUU4)