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

.