I have a score sheet that totals the scores for different QA catigories. If zero is entered in a particular cell I need the total to default to zero. I am using: =IF(C23=0,NA(),SUM(C6:C33)) which displays #NA is it possible to modify the formula to display zero, or is there a better formula?