Just a quick thanks for that explanation. I was reading these thinking that
the first parameter doesn't return a logical value. Turns out I was wrong.
"Shane Devenshire" wrote:
Hi,
Try =IF(SUM(B4:B13),SUM(B4:B13),"")
This works because if SUM(B4:B13) returns 0 Excel considers it FALSE, for
any other number Excel considers it TRUE.
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Darts via OfficeKB.com" wrote:
In cell b14 this is my formula - if these cells are blank i want the return
to be blank it is giving me a return of 0
=if(sum(b4:B13),"",sum(b4:B13))
--
Message posted via http://www.officekb.com