Leave Blank if No Value
Use
=IF(B17="","",sum(B6:B17))
"Linexe" wrote:
Hi
I am trying to use the below formual
=IF(B17="","",B6:B17)
But it is only giving me the value in B17 rather that the total from
B6 to B17.
Can anyone tell me where I am going wrong
many thanks
.
|