Leave Blank if No Value

  • Thread starter Thread starter Linexe
  • Start date Start date
L

Linexe

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
 
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
Click to expand...

try =IF(isblank(B17),"",sum(B6:B17))
 
If you want the total of B6:B17 you have to tell it to do so. The function
you want is SUM().

=IF(B17="","",SUM(B6:B17))
 
Hi

Try this

=IF(B17="","",SUM(B6:B17))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top