Leave Blank if No Value
 

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

Leave Blank if No Value
 

On Jan 28, 5:40*am, 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

try =IF(isblank(B17),"",sum(B6:B17))

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

.

Leave Blank if No Value
 

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.


"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

.

Leave Blank if No Value
 

Many thanks everyone for your help...